Javatpoint Logo
Javatpoint Logo

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.

Next TopicSQL Update




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA