Unable to insert multiple records

Question

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,