Which Transact-SQL operator should you use?

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?

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:
http://msdn.microsoft.com/en-us/library/ms175156.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Peter

Peter

just ‘cross apply’ I guess.