sql 列集合

STUFF((SELECT ','+CAST( TYZ_Bh  as varchar(10)) FROM #1 where 片区划分='江东' for xml path('')),1,1,'') 

原文地址:https://www.cnblogs.com/kunlunmountain/p/8796499.html