INSERT

Adding rows to a table with identity column

INSERT statement

INSERT statement

Data modification statements

MERGE statement

New sql features

Data modification statements

SQL data manipulation language

Table-values constructor

Data modification statements

SQL data manipulation language

Book