insert syntax

Here is the full syntax for the insert command:

insert [into] [database.[owner.]] {table_name | 
     view_name} [(column_list)] 
     {values (constant_expression 
     [, constant_expression]...) | select_statement}

NoteWhen you add text or image values with insert, all the data is written to the transaction log. You can use the writetext command to add these values without logging the long chunks of data that may comprise text or image values. See “Inserting data into specific columns” and “Changing text and image data”.