TABLE NAME AS A VARIABLE IN SQL

[Gina L. Hernandez]

Could somebody tell me what is the syntax for reading the name of a tabla
from a variable??. For example



declare @tabla varchar(10)

set @tabla = 'prompts'

select *
from @tabla

Thanks

 

[Scott Allen]

Are you using SQL Server?

You'll need to use some dynamic SQL to pull this off.
i.e.:

EXEC('SELECT * FROM ' + @tabla)

There are some tradeoffs to evaluate before you start using dynamic
SQL, as the following article discusses:

http://www.algonet.se/~sommar/dynamic_sql.html

HTH,