1.原始

http://s7/mw690/001VqPyKgy6EbKX8YrI16&690利用查询将结果用逗号隔开" TITLE="Sql 利用查询将结果用逗号隔开" />
2.利用语句

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

http://s16/mw690/001VqPyKgy6EbL2N4kv7f&690利用查询将结果用逗号隔开" TITLE="Sql 利用查询将结果用逗号隔开" />