SQL将多个字段查询出来拼接成一行

select stuff((select ','+fieldName  + ' as '  + alias from Table where a.No=No for xml path('')),1,1,'') as sqlJoint from 
Table as a where No='00001'
group by No