您可以使用该
UNPIVOT操作获取结果
SELECt col, valueFROM (SELECt CAST(col1 AS VARCHAR) AS col1, CAST(col2 AS VARCHAR) AS col2, CAST(col3 AS VARCHAR) AS col3, CAST(col4 AS VARCHAR) AS col4 FROM Table1) pUNPIVOT (value FOR col IN (col1, col2, col3, col4)) AS unpvt;
您可以使用该
UNPIVOT操作获取结果
SELECt col, valueFROM (SELECt CAST(col1 AS VARCHAR) AS col1, CAST(col2 AS VARCHAR) AS col2, CAST(col3 AS VARCHAR) AS col3, CAST(col4 AS VARCHAR) AS col4 FROM Table1) pUNPIVOT (value FOR col IN (col1, col2, col3, col4)) AS unpvt;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
