如何在SQL pivot中使用通配符

DECLARE @cols AS NVARCHAR(MAX)
DECLARE @query AS NVARCHAR(MAX)

-- 使用通配符生成要透视的列名
SET @cols = STUFF((SELECT DISTINCT ',' + QUOTENAME(column_name)
            FROM your_table
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)'),1,1,'')

-- 构建透视查询语句
SET @query = 'SELECT *
            FROM
            (
                SELECT column_name, value
                FROM your_table
            ) x
            PIVOT
            (
                MAX(value)
                FOR column_name IN (' + @cols + ')
            ) p '

-- 执行动态SQL查询
EXECUTE(@query)