You use Microsoft SQL Server 2012 database to develop a shopping cart application. You need to invoke a
table-valued function for each row returned by a query. Which Transact-SQL operator should you use?
A.
CROSS JOIN
B.
UNPIVOT
C.
PIVOT
D.
CROSS APPLY
Explanation:
Verified answer as correct.
Reference: http://msdn.microsoft.com/en-us/library/ms175156.aspx
pivot
0
1
D
0
0
D
https://technet.microsoft.com/en-us/library/ms175156(v=sql.105).aspx
0
0