34,576
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(1000)
select @sql = 'select '+convert(varchar,t_1)+'from table_a' from table_a
t_1表达式在你的SQL语句中没有出处
declare @sql varchar(1000)
set @sql = 'select '+convert(varchar,t_1)+'from table_a' from table_name
如果t_1是变量,里面是table_a的某个列名
declare @t_1 as varchar(10)
set @t_1 = 'XXX'
declare @sql varchar(1000)
set @sql = 'select convert(varchar,' + @t_1 + ') from table_a'
exec(@sql)
如果t_1是table_a的列名
declare @sql varchar(1000)
set @sql = 'select convert(varchar,t_1) from table_a'
exec(@sql)
declare @sql varchar(1000)
select @sql = 'select '+convert(varchar,t_1)+'from table_a' from table_a