Posted on 2020年9月14日 by Hana SELECT STUFF(( SELECT ',' + suba.列名 FROM dbo.表名 suba FOR XML PATH('') ), 1, 1, '') AS Name