CODEWITHSUNDEEP
sqlsql-server
MAS
MAS

Reputation: 311

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

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.

Upvotes: 6

Views: 22561

Answers (2)

Aitori
Aitori

Reputation: 11

Try this:

SET @T_variable :=(SELECT au_lname FROM Testing)

Adding a colon may help here.

Upvotes: 1

TechDo
TechDo

Reputation: 18659

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

Upvotes: 15

Related Questions