Microsoft Exam Questions

How would you accomplish this task?

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: