SQL$HELP72.HLB  —  INSERT  Arguments  VALUES value expr
    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.
Close Help