Microsoft Exam Questions

What action should you take?

You need to ensure that a stored procedure fails if an INSERT statment within the stored procedure fails. What
action should you take?

A.
THROW 51000, ‘Abort!’

B.
SET XACT_ABORT OFF

C.
SET XACT_ABORT ON

D.
TRY….CATCH