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
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%