Specifies a list of values to be added to the table as a single
row. The values can be specified through parameters, qualified
parameters, column select expressions, value expressions, or the
default values.
The values listed in the VALUES argument can be selected from
another table, but both tables must reside in the same database.
The number of values in the list must correspond to the number
of columns specified in the list of column names. If you did not
specify a column list, the number of values in the list must be
the same as the number of columns in the table. The first value
specified in the list is assigned to the first column, the second
value to the second column, and so on.
Values for IDENTITY, COMPUTED BY, and AUTOMATIC COLUMNS are not
able to be inserted so these column types are not considered for
the default column list.
See the SQL Online Help topic INSERT EXAMPLES for an example that
shows an INSERT statement with a column select expression.