xml模板 SQL數(shù)據(jù)庫，用forxmlpath字符串拼接，拼接內(nèi)容如何排序？
SQL數(shù)據(jù)庫，用forxmlpath字符串拼接，拼接內(nèi)容如何排序？SELECT b.列1，LEFT(List，LEN(List)-1) as Num FROM (SELECT 列1，(SELECT 列
SQL數(shù)據(jù)庫，用forxmlpath字符串拼接，拼接內(nèi)容如何排序？
SELECT b.列1，LEFT(List，LEN(List)-1) as Num FROM (SELECT 列1，(SELECT 列2 "，" FROM 表 WHERE 列1=a.列1 FOR XML PATH("")) AS ListFROM 表 a GROUP BY 列1) b