22,207
社区成员
发帖
与我相关
我的任务
分享
declare @s nvarchar(4000)
select name into #tmp_Table from sys.all_columns where object_name(object_id)='XXX'
Select @s=isnull(@s+',','')+quotename([name]) from #tmp_Table group by[name]
exec('select * from #tmp_Table pivot (max([name]) for [name] in('+@s+'))b')
declare @columnlist nvarchar(max)
select @columnlist=isnull(@columnlist+N',',N'')+name
from sys.all_columns
where object_name(object_id)='XXX'
select @columnlist