Insert SQL for multiple record
sql, sql-server, sql-server-2005
Solution
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');
Problem
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?