Which temporary storage object should you use?

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 table variable
C. a common table expression (CTE)
D. a derived table

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.