Insert multiple rows

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 […]