Which option should you enable?

You are writing a batch that contains multiple UPDATE statements to modify existing products. You have placed these updates into one explicit transaction. You need to set an option at the beginning of the transaction to roll back all changes if any of the updates in the transaction fail. Which option should you enable?

You are writing a batch that contains multiple UPDATE statements to modify existing products. You have placed these updates into one explicit transaction. You need to set an option at the beginning of the transaction to roll back all changes if any of the updates in the transaction fail. Which option should you enable?

A.
ARITHABORT

B.
XACT_ABORT

C.
IMPLICIT_TRANSACTIONS

D.
REMOTE_PROC_TRANSACTIONS



Leave a Reply 0

Your email address will not be published. Required fields are marked *