Câu 18: 70-465: Designing Database Solutions for Microsoft SQL Server 2012

You are building a stored procedure for a Windows Azure SQL Database. The procedure will add multiple rows to a table. You need to design the stored procedure to meet the following requirements:If any of the new rows violates a table constraint, then no further additions must be attempted and all changes made by the stored procedure must be discarded. If any errors occur, a row must be added to an audit table, and the original error must be returned to the caller of the stored procedure. What should you include in the design?

1. A. An explicit transaction that has XACT_ABORT disabled
2. B. An implicit transaction that has error handling enabled
3. C. An explicit transaction that has error handling enabled — đáp án hiện tại
4. D. An implicit transaction that has XACT.ABORT enabled