Sql Server-查询一列的数据进行拼接

select convert(VARCHAR(10),memberid) +',' from t_member where teamid = 1009 for xml path('') 

原文地址:https://www.cnblogs.com/dekevin/p/5344433.html