declare @name varchar(100) set @name='列名' exec('select '+@name+' from xxtable')
1、declare @name varchar(20) set @name='columnname' exec('select'+@name+'from xxtable')2、declare @name varchar(20) select @name = name from sysojbects where id = xxxxx exec('select * from '+@name)
TO:zxj971140(阿力) 你不仅仅穷,还可怜。就像马路的上
1。exec('select'+@name+'from xxtable') 2。exec('select * from '+@name)
or declare @name varchar(20),@sql varchar(1000) set @sql ='select @n = name from sysojbects where id = xxxxx'exec sp_execute @sql ,N'@n varchar(20) output', @name output
1,exec('select '+@name+'from xxxtable')2,declare @name varchar(20) select @name = name from sysojbects where id = xxxxxexec ('select * from(select '''+ @name+''' as Name)temp')
set @name='列名'
exec('select '+@name+' from xxtable')
set @name='columnname'
exec('select'+@name+'from xxtable')2、declare @name varchar(20)
select @name = name from sysojbects where id = xxxxx
exec('select * from '+@name)
你不仅仅穷,还可怜。就像马路的上
2。exec('select * from '+@name)
or
declare @name varchar(20),@sql varchar(1000)
set @sql ='select @n = name from sysojbects where id = xxxxx'exec sp_execute @sql ,N'@n varchar(20) output', @name output
select @name = name from sysojbects where id = xxxxxexec ('select * from(select '''+ @name+''' as Name)temp')