sql STUFF 分组 

1 ---将sql想关的数据放到一个字段里
2 select r.Region_Name,
3 STUFF((select ','+cast(c2.city_name as varchar(10)) [text()]
4 from City c2
5 inner join Region as r2 on c2.Region_id=r.Region_ID
6 where r2.Region_ID = r.Region_ID
7 for xml path('')),1,1,'') city_name
8 from Region as r

posted @ 2018-08-13 18:18  往事随风_go  阅读(779)  评论(0)  编辑  收藏  举报