Insert multiple records into SQL Server 2008 with one Insert statement
I recently read Pinal Dave’s article about inserting multiple records using one Insert statement in SQL Server 2008. This is a very useful feature of SQL Server 2008 that makes it much easier to insert several records at one time.
One thing to point out about this method, however, is that you can insert a maximum of 1000 value sets in any single Insert statement using this method.
Just something to be aware of when you are inserting records with this method.