using a variable for a table_name in select

[skertz]

It is possible to declare a variable, set it and then use it in a select statement like e.g:

declare @my_var varchar(31), @db varchar(31)
set @db = 'TEST'
set @my_var = @db + '..sysobjects'

select * from @my_var


I'm looking to query other database tables from inside a procedure.

 

[cdukes]

YES, but you will have to use exec to execute the query

eg.

declare @my_var varchar(31)
declare @db varchar(31)

set @db = 'TEST'
set @my_var = @db + '..sysobjects'

exec 'select * from ' + @my_var


hope this helps,

Chris Dukes

 

[skertz]

Thanks Chris!! You got me going down the right path.

The EXEC works, but you must enclose it in () like the following.

exec ('select * from' + @my_var)

THANKS AGAIN!!!