Home Forums SQL Server 7,2000 T-SQL variable in the FROM clause RE: variable in the FROM clause
rhunt
SSCertifiable
Points: 5868
More actions
March 18, 2005 at 8:50 am
#547798
declare @selField varchar(50)
declare @selTbl varchar(50)
declare @sql varchar(100)
set @selField = 'name'
set @selTbl = 'sysobjects'
SET @sql = 'SELECT ' + @selField + ' from ' + @selTbl
EXEC(@sql)