in MySQL there is this syntax for using a single insert for multiple records:
INSERT INTO x (a,b)
VALUES
('1', 'one'),
('2', 'two'),
('3', 'three')
is there similar syntax in MS SQL Server 2000 ?
i came up with
insert (a, b)
select '1', 'one'
union
select '2', 'two'
union
select '3'...