SQL查询结果集拆分成字符串

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,'');