Row constructor is the new feature introduced in SQL Server 2008 onward edition to insert multiple rows by writing a single INSERT statement.
Row constructor in SQL Server specifies a set of row value expressions to be constructed into a table. The Transact-SQL table value constructor allows multiple rows of data to be specified in a single DML statement. The table value constructor can be specified in the VALUES clause of the INSERT statement, in the USING <source table> clause of the MERGE statement, and in the definition of a derived table in the FROM clause.
It saves a lot of time if you want to insert multiple records into a SQL Server table.
-- Before SQL Server 2008 – Multiple INSERT statements required.
INSERT INTO dbo.Employee (EmpID, EmpName)
VALUES (1, 'Jack')
INSERT INTO dbo.Employee (EmpID, EmpName)
VALUES (2, 'William')
Join the conversation! Your thoughts help the community grow.