Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Below is an example of introducing an INSERT statement with Columns and Stubbed Values.

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

1. Connect to
the Server
2. Automate
Insert Statement
3. Select Table4. Move the Cursor5. Automate
Introduce Columns
Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

Image Removed

Image Added

6. Column Names
without typing
7. Move the Cursor8. Introduce
Stubbed Values
 
9. Value Stubs
without typing


The SQL Automation features in Aqua Data Studio (the "Automate" pull-down menu) is to cut down on the number of keystrokes you make while writing SQL statements. Here is an example of how to automate the writing of basic INSERT statements with COLUMNS and value stubs.

Automate INSERT COLUMNS

...