行转列的问题

[sxq129601]

select name from sys.all_columns where object_name(object_id)='XXX'

结果要变成
aaa,bbb,ccc,ddd,eee,fff,ggg

[唐诗三百首]

declare @columnlist nvarchar(max)

select @columnlist=isnull(@columnlist+N',',N'')+name 
 from sys.all_columns 
 where object_name(object_id)='XXX'

select @columnlist

[顺势而为1]

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')

[shanghaivincent]

SELECT STUFF((SELECT ','+name FROM sys.all_columns where object_name(object_id)='xxxx' for xml path('')),1,1,'')