用动态SQL语句吧: 如: declare @sql varchar(8000),@col varchar(20) ,@table varchar(20) set @table='xx' set @col='tt' set @sql='select '+ @col+' from '+@table+' where '+ @col+'=1' exec(@sql)
declare @sql varchar(8000),@col varchar(100),@table varchar(100) select @col='a' select @table='b' select @sql='select '+@col+' from '+@table+' where '+@col+'=1' execute (@sql)
如:
declare @sql varchar(8000),@col varchar(20) ,@table varchar(20)
set @table='xx'
set @col='tt'
set @sql='select '+ @col+' from '+@table+' where '+ @col+'=1'
exec(@sql)
select @col='a'
select @table='b'
select @sql='select '+@col+' from '+@table+' where '+@col+'=1'
execute (@sql)