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.