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
行转列(FOR XML PATH),布布扣,bubuko.com
行转列(FOR XML PATH)
原文：http://www.cnblogs.com/gossip/p/3878515.html
