How to store select statement result to table variable in sql server

Question

Declare @T_variable table(name varchar(200))
SET @T_variable =(SELECT au_lname FROM Testing)

Error Message. Msg 137, Level 16, State 1, Line 2 Must declare the scalar variable "@T_variable".

Note :- select statement result will give multiple rows.

I try to capture the select result in table variable.But i failed. Is there any way to capture the select result to Table variable Dynamically.

Thanks in advance.

TechDo · Accepted Answer · 2013-11-15 07:26:06Z

15

Please try below query instead since you have declared a table variable instead of a datatype variable.

Declare @T_variable table(name varchar(200))
insert into @T_variable 
SELECT au_lname FROM Testing

answered Nov 15, 2013 at 7:26

TechDo

18.7k3 gold badges55 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pang · Accepted Answer · 2017-08-12 03:17:45Z

1

Try this:

SET @T_variable :=(SELECT au_lname FROM Testing)

Adding a colon may help here.

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Aug 4, 2017 at 11:59

Aitori

114 bronze badges

Is your answer better than the selected answer?

someone may find this useful.@jhhoff02