SQL INSERT MULTIPLE ROWS
Many times developers ask that is it possible to insert multiple rows into a single table in a single statement. Currently developers have to write multiple insert statement when they insert values in a table. It is not only boring, also time consuming. To get rid from this you should try this syntax. Actually there are three different methods to insert multiple values into a single table.
Insert multiple values in SQL server
1. SQL INSERT: (TRADITIONAL INSERT)
2. INSERT SELECT: (SELECT UNION INSERT)
3.SQL Server 2008+ Row Construction
Note:Row Constructor is a new feature for SQL Server 2008. It is not supported by SQL Server 2005.