SELECT ',' + USER_ID FROM test FOR XML PATH('')
SELECT STUFF((SELECT ',' + USER_ID FROM test for xml path('')),1,1,'')
多表联查 ,得到结果集拆分为字符串
SELECT STUFF((SELECT ',' + [字段] from [表名] Where [字段] in (SELECT [字段] FROM [表名] t1
inner join (SELECT [字段] FROM [表名] s1
inner join (SELECT [字段] FROM [表名] where [字段]=59 ) s2
on s1.[FDepID]=s2.[FDepID] where [FIsPush] = 1) t2
on t1.[FUserID]=t2.[FUserID] ) FOR XML PATH('')),1,1,'');