Unable to insert multiple records

Jul 4 2019 6:34 AM

Hi All,

Unable to insert multiple records in SQL server 2005.

Command:

insert into emp (eno,ename,esex,eage,esal,dno) values (4,'Kat','M',40,40000,3),(5,'Mary','F',35,30000,5),(6,'Nancy','F',40,40000,6)

But, i am getting the below error message.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ','.

Pls help.

-Rgds,

Answers (8)