SQL 多行合并一行

select stuff((select ',' + CONVERT(VARCHAR(50),id)+'' from tab_menu  group by id for xml  path('')),1,1,'')

原文地址:https://www.cnblogs.com/LuoEast/p/9050735.html