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.

Traditional method (simple insert)
SQL insert select
SQL server 2008+ Row Construction

Insert multiple values in SQL server

1. SQL INSERT: (TRADITIONAL INSERT)

INSERT INTO student (ID, NAME)
VALUES (1, 'ARMAAN');
INSERT INTO student (ID, NAME)
VALUES (2, 'BILLY');
INSERT INTO student (ID, NAME)
VALUES (3, 'CHARLIE');

TO CLEAN-UP:

2. INSERT SELECT: (SELECT UNION INSERT)

INSERT INTO student (ID, NAME)
SELECT 1, 'ARMAAN'
UNION ALL 
SELECT 2, 'BILLY'
UNION ALL
SELECT 3, 'CHARLIE';
TO CLEAN-UP:
TRUNCATE TABLE student;

3.SQL Server 2008+ Row Construction

INSERT INTO student (ID, NAME)
VALUES (1, 'ARMAAN'), (2, 'BILLY'), (3, 'CHARLIE');
TO CLEAN-UP:
DROP TABLE student;

Note:Row Constructor is a new feature for SQL Server 2008. It is not supported by SQL Server 2005.

Next TopicSQL Update

<<prev next>>

SQL Tutorial

SQL Database

SQL Table

SQL Select

SQL Clause

SQL Order By

SQL Insert

SQL Update

SQL Delete

SQL Join

SQL Keys

PL/SQL Tutorial

Interview

Quiz

SQL INSERT MULTIPLE ROWS