unpivot

unpivot

美 　英

• 网络逆透视；为行；取消枢纽

例句

UNPIVOT does not reproduce the original table-valued expression result because rows have been merged.

而UNPIVOT不会重现原始表值表达式的结果，因为行已经被合并了。

UNPIVOT performs the opposite operation to PIVOT by rotating columns of a table-valued expression into column values.

UNPIVOT与PIVOT执行相反的操作，将表值表达式的列转换为列值。

The new PIVOT and UNPIVOT operators rotate result sets by which columns become rows and rows become columns.

新的PIVOT和UNPIVOT运算符对结果集进行旋转，这样，列变成了行，行变成了列。

UNPIVOT performs almost the reverse operation of PIVOT, by rotating columns into rows.

UNPIVOT将与PIVOT执行几乎完全相反的操作，将列转换为行。

Finally, perform an unpivot on the distribution channels.

最终，在分销渠道上执行逆透视。

You can use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.

可以使用PIVOT和UNPIVOT关系运算符将表值表达式更改为另一个表。