Insert multiple rows

Posted on March 10, 2008


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)

(‘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.