Sql 列转行

SELECT vcaa, vcbb, ISNULL(( SELECT vcCN + ‘,‘
FROM TableB b
WHERE a.vcaa= b.vcaa
FOR
XML PATH(‘‘) ), ‘‘) AS vcNameList
FROM TableA a

Sql 列转行

原文：http://www.cnblogs.com/ghelement/p/6656590.html