You need to design a stored procedure that contains a transaction. If an error condition
causes the transaction to roll back, a temporary result set must be available to the query
that follows the failed transaction. Which temporary storage object should you use?

A.
a temporary table

B.
a derived table

C.
a table variable

D.
a common table expression (CTE)