SQL Server :如何获取未知数量的字段作为列名？

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'YourTableName'

SELECT COLUMN_NAME
FROM sys.dm_exec_describe_first_result_set('YourQuery', NULL, 0)

DECLARE @columns NVARCHAR(MAX)

SELECT @columns = STUFF(
    (
        SELECT ',' + COLUMN_NAME
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE TABLE_NAME = 'YourTableName'
        FOR XML PATH('')
    ),
    1, 1, ''
)

PRINT @columns

DECLARE @sql NVARCHAR(MAX)

SET @sql = 'SELECT ' + @columns + ' FROM YourTableName'

EXEC(@sql)