am getting a syntax error on line 3. The datatypes are varchars except
for status which is numeric.
insert S (S#, SNAME, STATUS, CITY)
values
('S2', 'Jones', 10, 'Paris'),
('S3', 'Blake', 30, 'Paris'),
('S4', 'Clark', 20, 'London'),
('S5', 'Adams', 30, 'Athens');
What's wrong?
Thanks,
SashiYou 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
--|||The real problem is that SQL Server does not yet support SQL-92 syntax,
in spite of having the power to do so. Your choices are:
1) use a series of INSERT INTO statements (notice that INSERT is a
proprietary shorthand, not Standard SQL).
2) use a proprietary SELECT ..UNION ALL chain to build a table the same
way that the VALUES table constructor would.
