September 2010
Intermediate to advanced
1704 pages
111h 8m
English
SQL Server 2008 provides a new method to insert data to SQL Server tables, referred to as row constructors. Row constructors are a feature that can be used to simplify data insertion, allowing multiple rows of data to be specified in a single DML statement. Row constructors are used to specify a set of row value expressions to be constructed into a data row.
Row constructors can be specified in the VALUES clause of the INSERT statement, in the USING clause of the MERGE statement, and in the definition of a derived table in the FROM clause. The general syntax of the row constructor is as follows:
VALUES ( { expression | DEFAULT | NULL |} [ ,...n ] ) [ ,...n ]
Each column of data defined in the VALUES clause is separated from ...