行转列(FOR XML PATH)

SELECT (SELECT ac.ColName+',' FROM T1 AS ac FOR XML PATH('')) AS ColName,
       (SELECT ac.colTitle+',' FROM T1 AS ac FOR XML PATH('')) AS colTitle

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/gossip/p/3878515.html