Insert into table from table variable?

Question

DECLARE @t TABLE
(
ID uniqueidentifier,
ID2 uniqueidentifier
)

...insert into @t ...do stuff to @t

INSERT INTO testTable (Id, Id2) VALUES (SELECT ID, ID2 from @t) -does not work?

Just think of it as a normal table, you can do the usual `INSERT INTO ... SELECT ...` syntax. — Bridge, Feb 08 '13 at 13:46

score 9 · Accepted Answer · answered Feb 08 '13 at 13:44

9

This is how you should do that:

INSERT INTO testTable (Id, Id2)
SELECT ID, ID2 
from @t

answered Feb 08 '13 at 13:44

gzaxx

score 0 · Answer 2 · answered Feb 08 '13 at 13:45

0

How about this?

INSERT INTO testTable SELECT ID, ID2 from @t

answered Feb 08 '13 at 13:45

Sergio

2 Answers2