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
What action should you take?