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 Modified

Image Modified

Image Modified

Image Modified

Image Modified

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

Image Modified

Image Modified

Image Modified

Image Modified

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

...