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?
A.
An explicit transaction that has XACT_ABORT disabled
B.
An implicit transaction that has error handling enabled
C.
An explicit transaction that has error handling enabled
D.
An implicit transaction that has XACT.ABORT enabled
Explanation:
http://technet.microsoft.com/en-us/library/ms175127(v=SQL.105).aspx