Insert Multiple Rows

[testeng]

Hi,
Can some one tell me why this statement will not work I have tried it with Acess 2000 or SQL2000.

Insert into TABLE1 (FEILD1,FIELD2) values (1,1),(2,2),(3,3);

It errors out everytime I have never tried to do multiple inserts before just heard about it has anyone had any success?

Thanks in advance

 

[tlbroadbent]

You must use 3 INSERT statements.

Insert into TABLE1 (FEILD1,FIELD2) values (1,1);
Insert into TABLE1 (FEILD1,FIELD2) values (2,2);
Insert into TABLE1 (FEILD1,FIELD2) values (3,3);
If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm