Set a variable to result of executed dynamic query

[rupeshjain]

Is it possible or not:
declare @query varchar(500)
declare @var varchar(50)
@query='select U_Id from tblUser where U_Id='+100
@var = exec(@query)


plz help me............. .

[Jim Doherty]

Is it possible or not:
declare @query varchar(500)
declare @var varchar(50)
@query='select U_Id from tblUser where U_Id='+100
@var = exec(@query)


plz help me............. .

Your variable is assigned at the point when you return the value of your presumably 'single' value sql execution return value into the variable @query. Compare my layout to yours

 
declare @query varchar(500)
declare @var varchar(50)
 
SELECT @query = U_Id from tblUser where U_Id=100

If you then need to pass the value from @query to @var
then thats a matter for you
ie

 SELECT @var=@query

Regards

Jim :)

[chupok]

Is it possible or not:
declare @query varchar(500)
declare @var varchar(50)
@query='select U_Id from tblUser where U_Id='+100
@var = exec(@query)


plz help me............. .

try to use EXECUTE sp_executesql

[ck9663]

Looks like you're trying to store the value of u_id to a variable. Be careful with SELECT, it could lead to undetected logical error, not syntax errors.

Depending on your requirement, a SET command might also be considered.

Read my blog about the difference between SET and SELECT

Good luck.

-- CK