You need to ensure that a stored procedure fails if an INSERT statement 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
You need to ensure that a stored procedure fails if an INSERT statement 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