Insert SQL for multiple record

Question

I get the error message when I run the following query in MSSQL Server 2005.

Error Message is Incorrect syntax near ','. I think query is ok. But I don't know why I get error.

INSERT INTO PERSON (ID, EMP_NAME) VALUES ('E001', 'AAA'), ('E002', 'BBB');

SQL Server does not support?

Answer 1

If your DB is lower than SQL Server 2008

INSERT INTO PERSON (ID, EMP_NAME) VALUES ('E001', 'AAA');
INSERT INTO PERSON (ID, EMP_NAME) VALUES ('E002', 'BBB');