-- SQL Server 版本是 2017 或更高：

SELECT STRING_AGG(COLUMN_NAME, ',') WITHIN GROUP (ORDER BY ORDINAL_POSITION) AS column_names

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'User';

--SQL Server 版本是比 2017版本低的使用下面的语句：

SELECT STUFF(

(SELECT ',' + COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'User'

ORDER BY ORDINAL_POSITION

FOR XML PATH('')), 1, 1, '') AS column_names;