Question No 19
You use Microsoft SQL Server 2012 database to develop a shopping cart application.
You need to rotate the unique values of the ProductName field of a table-valued expression into multiple columns in the output.
Which Transact-SQL operator should you use?
A. CROSS JOIN
B. CROSS APPLY
C. PIVOT
D. UNPIVOT
Correct Answer: C
Explanation/Reference:http://technet.microsoft.com/en-us/library/ms177634.aspx
No comments:
Post a Comment
Note: only a member of this blog may post a comment.