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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2264
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
