Insert multiple values into SQL Server table

Question

I'm kind of new in using SQL Server and I have this problem. I don't know how do I have to concatenate in order to insert into one column table multiple values.

INSERT INTO Table (Column) 
VALUES ('Name'+','+' Last name',);,('Name'+','+'Last name',);

And I get this error:

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near ','.

Possible duplicate of [How do I insert multiple rows WITHOUT repeating the "INSERT INTO dbo.Blah" part of the statement?](http://stackoverflow.com/questions/2624713/how-do-i-insert-multiple-rows-without-repeating-the-insert-into-dbo-blah-part) — Michael Freidgeim, Jun 09 '16 at 01:06

score 0 · Accepted Answer · answered Apr 25 '15 at 11:08

0

INSERT INTO Table (Column) 
VALUES ('Name'+','+ 'Last name')  --<-- no comma required inside the paranthesis
      ,('Name'+','+ 'Last name');  --<-- only need semi-colon here

answered Apr 25 '15 at 11:08

M.Ali

67,945
13
101
127

score 0 · Answer 2 · answered Apr 25 '15 at 11:25

0

Use should use || symbols for concatenate. Example: SELECT first_name || ' ' || last_name FROM hr.employees;

answered Apr 25 '15 at 11:25

nzeshka

9
2

this is for sql server. you cannot concatenate using `||` – ughai Apr 25 '15 at 11:32

Insert multiple values into SQL Server table

2 Answers2