Inserting multiple rows in a single SQL query? [duplicate]
In SQL Server 2008 you can insert multiple rows using a single SQL INSERT statement. For reference to this have a look at MOC Course 2778A – Writing SQL Queries in SQL Server 2008. For example: