select Name + ‘,‘ from A FOR XML PATH(‘‘)
若 Name不是 varchar类型，先转
select CAST(Name AS varchar) + ‘,‘ from A FOR XML PATH(‘‘)
去，号
select left(a,len(a)-1) from (select (select CAST(Name AS varchar) + ‘,‘ from A FOR XML PATH(‘‘)) a)b
原文：https://www.cnblogs.com/yifa/p/11346989.html