unpivot 中文意思是什麼
unpivot
解釋
逆透視-
The unpivot transformation includes the
逆透視轉換包括 -
Configuring the unpivot transformation
配置逆透視轉換 -
Unpivot transformation editor
逆透視轉換編輯器 -
To unpivot the table, assume the result set produced in the previous example is stored as
若要對表進行逆透視,請假定在上一個示例中生成的結果集是作為 -
Aggregate, pivot, unpivot, and slowly changing dimension transformations, for common data warehousing tasks
聚合、透視、逆透視和漸變維度轉換,用於常見數據倉庫任務。 -
Pivot and unpivot transformations, for creating normalized data rows from non - normalized data and vice versa
透視和逆透視轉換,用於從非規范化的數據創建規范化的數據行,以及從規范化的數據創建非規范化的數據行。 -
After the unpivot transformation normalizes the data set, the data set contains a different row for each product that the customer purchased
逆透視轉換將數據集規范化之後,客戶購買的每種產品在該數據集中各佔一行。 -
The unpivot transformation makes an unnormalized dataset into a more normalized version by expanding values from multiple columns in a single record into multiple records with the same values in a single column
逆透視轉換將來自單個記錄中多個列的值擴展為單個列中具有同樣值的多個記錄,使得非規范化的數據集成為較規范化的版本。 -
New pivot and unpivot operators relational operators
新的pivot和unpivot運算符(關系運算符) -
In the unpivot clause, lists the columns in
在unpivot子句中,列出 -
When used with unpivot,
與unpivot一起使用時, -
The new pivot and unpivot operators rotate result sets by which columns become rows and rows become columns
新的pivot和unpivot運算符對結果集進行旋轉,這樣,列變成了行,行變成了列。 -
When a derived table, rowset or table - valued function, or operator clause such as pivot or unpivot is used, the required
如果使用派生表、行集或表值函數或者運算符子句(如pivot或unpivot ) ,則在子句結尾處必需的 -
These operations were possible in earlier versions of sql server, but required complex logic that is now simplified using pivot and unpivot
在早期版本的sql server中可以進行這些操作,但需要復雜邏輯;現在通過使用pivot和unpivot這一邏輯得到了簡化。
分享友人