No. You'd have to do separate insert statements.
-----Original Message----- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 19:15 To: SQL Subject: Does this work in SQL server 2000? Hi, This SQL statement works in MySQL, and I am wondering if it works in SQL server 2000. I don't have access to SQL server 2000 at the moment to test it. Can someone tell me if SQL server 2000 support this kind of insert statement? INSERT INTO Products (ProductCode, ArtistName, AlbumTitle, Category, Description, ProductPrice) VALUES ('8601', '86 (the band)', 'True Life', 'Rock', 'The debut album rocks', '14.95'), ('pf01', 'The first CD', 'Paddlefoot', 'Rock', 'This 68-minute.', '12.55'), ('pf02', 'The second CD', 'Paddlefoot', 'Rock', 'The second.', '12.85'), ('jr01', 'Genuine Wood Grained Finish', 'Joe Rut', 'Folk', 'This well-crafted.', '14.95') Thanks. Johnny ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
