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.

1. Traditional method (simple insert)
2. SQL insert select
3. SQL server 2008+ Row Construction

Insert multiple values in SQL server

1. SQL INSERT: (TRADITIONAL INSERT)

TO CLEAN-UP:

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.