You work as a database developer at ABC.com. You want to create a Transact-SQL query will call
a table-valued function for every row the query returns.
How would you accomplish this task?
A.
You should make use of a UNION.
B.
You should make use of a CONVERT function.
C.
You should make use of an INNER JOIN.
D.
You should make use of a Trigger.
E.
You should make use of a CAST function.
F.
You should make use of an OUTER JOIN.
G.
You should make use of a CROSS APPLY.
H.
You should make use of the FORMAT function.
Explanation:
?
There are two forms of APPLY: CROSS APPLY and OUTER APPLY. CROSS APPLY returns only rows from the outer table that produce a result set from the table-valued function. OUTER APPLY returns both rows that produce a result set, and rows that do not, with NULL values in the columns produced by the table-valued function
G
Basically, the key point here is a table-valued function. since joining table-valued function cant be done with JOIN, then CROSS APPLY/OUTER APPLY is used. This question would have been more confusing if there was OUTER APPLY included