22,209
社区成员
发帖
与我相关
我的任务
分享
declare @strs varchar(10)
declare @D15 varchar(10)
set @D15='1235'
print @D15
declare @strs nvarchar(max)
select @strs='declare @D15 nvarchar(10) set @D15=''1235'' print @D'+cast(15 as varchar(max))
print @strs --declare @D15 nvarchar(10) set @D15='1235' print @D15
exec(@strs) --1235
declare @D15 varchar(10)
set @D15='1235'
select @D15
declare @column varchar(10)
set @column='D15'
exec('select '+@column +' from Hp_KQ_KqMX')
declare @column varchar(10)
set @column='D15'
exec ('select '+@column=' from Hp_KQ_KqMX')
declare @column varchar(10)
set @column='D15'
exec ('select '+@column=' from Hp_KQ_KqMX
exec('select '+@column + ' from hp_kq_kqmx')