Row Constructor in SQL Server 2008 - Insert multiple rows with a single statement

By [)ia6l0 iii

Have you had a look at the Row Constructor in SQL Server 2008?

The syntax is pretty simple:

INSERT INTO tablename (column1, column2)
VALUES
(r1c1value, r1c2value)
,(r2c1value, r2c2value)
,(r3c1value, r3c2value)

Row Constructor in SQL Server 2008 - Insert multiple rows with a single statement (814 Views)