Posted by David Portas on 06/18/05 19:04

You have to use the INSERT... SELECT form to insert multiple rows.

INSERT INTO S (s#, sname, status, city)
SELECT 'S2', 'Jones', 10, 'Paris' UNION ALL
SELECT 'S3', 'Blake', 30, 'Paris' UNION ALL
SELECT 'S4', 'Clark', 20, 'London' UNION ALL
SELECT 'S5', 'Adams', 30, 'Athens' ;

--
David Portas
SQL Server MVP
--

• Next in forum: Re: What happens if a table has no Primary Key?
• Prev in forum: Re: xp_startmail return code checking
• Thread view: Re: Multiple insert

[Reply to this message]