TSQL question - INSERTing multiple rows simultaneously

[NuclearNed]

I think this can be done, but I'm drawing blanks on the exact syntax...

I want to do something like this:

INSERT table
VALUES
(
(1, 'record1'),
(2, 'record2'),
(3, 'record3')
)

At least it seems like I've done this before... where am I going wrong?

 

[Cerebus451]

I think you want to eliminate the outer '(' ')' pair after values. Just "VALUES (a,b), (c,d), (e,f)"

Edit: Taken from this Wiki page. It does mention this won't work on SQL Server, have to do a funky SELECT/UNION ALL construct.

 

[NuclearNed]

Originally posted by: Cerebus451
I think you want to eliminate the outer '(' ')' pair after values. Just "VALUES (a,b), (c,d), (e,f)"

Edit: Taken from this Wiki page. It does mention this won't work on SQL Server, have to do a funky SELECT/UNION ALL construct.

Thanks!