SELECT STUFF((SELECT ','+字段名 FROM 表名 for xml path('')),1,1,'') 转载于:https://www.cnblogs.com/Gold-fangjin/p/6930085.html