sqlserver2005之后列数据转字符串

select stuff((select ','+ 字段 from #table a order by 字段 desc for xml path('')),1,1,'')