insert (minimum)

Adds new rows to a table or view.

Syntax

Transact-SQL Syntax

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

ODBC Syntax

INSERT INTO table_name[(column_identifier[,column_identifier]
 ...)]

{query_specification|VALUES(insert_value
[,insert_value]...)

values – is a keyword that introduces a list of expressions.
? – specifies parameters passed by Adaptive Server/CIS at the time the insert command is executed.
column_list – is a list of one or more columns to which data is to be added. The columns can be in any order, but the incoming data (whether in a values clause or select clause) is in the same order.

Example 1 – inserts new titles with ? expression values.

insert titles
 (title_id, title, type, pub_id, notes, pubdate,contract)
 values (?, ?, ?, ?, ?, ?, ?)

Any valid object in the catalog can be substituted for table_name, view_name, and so on.
Adaptive Server/CIS passes the insert command to DirectConnect as this series of dynamic SQL commands:

prepare

execute

close

deallocate
The values in the values list are passed as dynamic SQL parameters.