sql server 将一列数据用指定字符拼接

 select convert(varchar(max), (select ',' + name from Province FOR XML PATH ( '' )) )
原文地址:https://www.cnblogs.com/xiaonangua/p/14850190.html