delcare @a nvarchar(12)
declare @sql varchar(1000)
set @a='name'
set @sql='select '+@a +'From Table where id=2'
exec(@sql)
declare @sql varchar(1000)
set @a='name'
set @sql='select '+@a +'From Table where id=2'
exec(@sql)
declare @field sysname --变量做列名
set @tablename ='table1'
set @filed ='field_name'
exec ('select '+@field+' from '+@tablename+'')
declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from table1'
exec sp_executesql @sqls,N'@a int output',@num output
select @num