inserting multiple rows

[alexerm]

Is there way in MS SQL to insert mulptiple rows at the same time?

I'm trying to achieve something like this(I know it works in DB2):

---------------------------------
INSERT INTO mytable
(a,b)
VALUES
(1,2),
(5,4),
(15,2),
....
--------------------------------


Thanks

 

[sunila7]

Try this

INSERT INTO #t
(a,b,c)
SELECT 1,5,15
UNION
SELECT 2,4,2


Sunil