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 ...
原创
2019-12-18 10:06:23 ·
881 阅读 ·
0 评论