sqlserver 把SELECT结果集中一列的所有的值 用逗号隔开放进一个字段内

SELECT  STUFF(( SELECT  ',' +convert(VARCHAR, USER_NAME) FROM TE_USER FOR XML PATH('')), 1, 1, '') AS UserNameSELECT  STUFF(( SELECT  ',' +convert(VARCHAR, USER