Exam4Training

Which Transact-SQL operator should you use?

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

Answer: C

Explanation:

http://technet.microsoft.com/en-us/library/ms177634.aspx

Latest 70-461 Dumps Valid Version with 232 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version