1.原始
SELECT B.tablename ,
LEFT(StuList, LEN(StuList) - 1) AS ArrayList
FROM ( SELECT tablename ,
( SELECT columnname + ','
FROM DataService
WHERE tablename = A.tablename
FOR
XML PATH('')
) AS StuList
FROM DataService A
GROUP BY tablename
) B