Specifying INSERT statements in the SQL Query Builder
Using an INSERT statement, you can insert rows from a values set or from a subquery results table into a database table.
Before you begin
There might be variations in syntax depending on the database vendor that you are using. If you use the SQL Query Builder to create the INSERT statement, the tool attempts to create the correct syntax.
If
you insert a row from a set of values, the default value that is shown
for each column depends on how the column was defined when the table
was created.
- The cell value is a pair of single quotation marks. Fill in the value.
Before you specify an INSERT statement, create the statement in the SQL Query Builder.
Procedure
To specify an INSERT statement in the SQL Query Builder: