Insert multiple rows in single SQL Query


There are many different ways you can insert multiple rows in a single SQL Query.
When I was fresher, many times I face this question in the interview, can you please write a script which can insert multiple rows. See the following scripts that may help you.

Suppose we have a table Customer which contains FirstName, LastName.


CREATE TABLE #CUSTOMER(
FirstName VARCHAR(50),
LastName VARCHAR(50)
)


Script 1:


INSERT INTO #CUSTOMER(FirstName,LastName)
VALUES ('Dilip','Singh'),('Ashish','Singh'),('Vipul','Bhatt')

SELECT * FROM #CUSTOMER


Script 2:


INSERT INTO #CUSTOMER(FirstName,LastName)
SELECT 'Dilip','Singh'
UNION ALL
SELECT 'Ashish','Singh'
UNION ALL
SELECT 'Vipul','Bhatt'

SELECT * FROM #CUSTOMER


Script 3:


INSERT INTO #CUSTOMER(FirstName,LastName)
EXEC(
                        'SELECT ''Dilip'',''Singh''
                        SELECT ''Ashish'',''Singh''
                        SELECT ''Vipul'',''Bhatt'''
            )

SELECT * FROM #CUSTOMER




No comments:

Post a Comment

Please do not enter any spam link in the comment box.

NUnit : Introduction

There are several unit test tools in the market, but one of them is NUnit, the most popular tool for doing unit testing. So in this tutorial...