Using the INSERT Statement

The INSERT statement allows you to insert data without first putting it into a flat file.

• Inserting Specified Values Row by Row
  To add specified values to a table row by row, use Syntax 1 for the INSERT statement. SAP Sybase IQ inserts the first value you specify into the first column you specify, the second value you specify into the second column, and so on.
• Inserting Selected Rows from the Database
  You can insert any number of rows of data, based on the results of a general SELECT statement.