Freelancer Freelancer - 7 months ago 14
SQL Question

insert multiple rows in single SQL

I am trying to insert multiple rows with SQL statement.

For that i refered this question.

According to top scored answer in this qestion, i made following query:

INSERT INTO login
(LogInID,Password)
UNION ALL
SELECT 'Name1','pass1'
UNION ALL
SELECT 'Name2','pass2'


But when i try to execute this one, it gives me error:

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'UNION'.


What can be the mistake in this query?

Is this a wrong approach?

Please help me.

NOTE: I am using SQL SERVER 2005

Answer

you have to remove UNION ALL before the first SELECT.

INSERT INTO login (LogInID,Password)
SELECT 'Name1','pass1'
UNION ALL
SELECT 'Name2','pass2'
Comments