Microsoft
70-457 · Question #91
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…
The correct answer is D. CROSS APPLY. See the full explanation below for the reasoning.
Question
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?
Options
- ACROSS JOIN
- BUNPIVOT
- CPIVOT
- DCROSS APPLY
How the community answered
(25 responses)- A16% (4)
- B4% (1)
- C4% (1)
- D76% (19)
Community Discussion
No community discussion yet for this question.