You are currently browsing the category archive for the 'Row Constructors' category.
How many times have we had to write multiple INSERT INTO statements? Well, SQL Server 2008 comes to the rescue. Its a small feature but still very useful.
You can now insert multiple rows into a table in a single statement.
INSERT INTO T1 (Col1,Col2,Col3)
VALUES
(‘Row1′, ‘Value’,‘Test’),
(‘Row2′, ‘Value’,‘Test’),
(‘Row3′, ‘Value’,‘Test’)
This inserts 3 rows into the T1 table. Certainly time-saving and makes those sometimes hefty insert scripts smaller.
