像这样吗？
SELECt BookID, Price, ISBN, PagesFROM( SELECt BookID, Key, Value FROM yourTable) AS SourceTablePIVOT( SUM(Value) FOR Key IN (Price, ISBN, Pages)) AS PivotTableORDER BY BookID
http://technet.microsoft.com/zh-
cn/library/ms177410(SQL.105).aspx
像这样吗？
SELECt BookID, Price, ISBN, PagesFROM( SELECt BookID, Key, Value FROM yourTable) AS SourceTablePIVOT( SUM(Value) FOR Key IN (Price, ISBN, Pages)) AS PivotTableORDER BY BookID
http://technet.microsoft.com/zh-
cn/library/ms177410(SQL.105).aspx
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
