Browsing All Posts filed under »Row Constructors«

Insert multiple rows

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) VALUES (‘Row1’, ‘Value’,‘Test’), (‘Row2’, ‘Value’,‘Test’), (‘Row3’, ‘Value’,‘Test’) This inserts 3 […]