What should you include in the design?

You are building a stored procedure for a SQL Azure 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 implicit transaction that has XACT_ABORT enabled
B . An explicit transaction that has XACT_ABORT disabled
C . An implicit transaction that has error handling enabled
D . An explicit transaction that has error handling enabled

View Answer

Answer: D

Explanation:

References:

http://technet.microsoft.com/en-us/library/ms175127(v=SQL.105).aspx