70-461 Exam Braindumps – Microsoft 70-461 Exam Questions Dumps4download

Question NO :  24

You create a stored procedure that will update multiple tables within a transaction.You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back.Which Transact-SQL statement should you include at the beginning of the stored
procedure?

A. SET XACT_ABORT ON
B. SET ARITHABORT ON
C. TRY
D. BEGIN
E. SET ARITHABORT OFF
F. SET XACT_ABORT OFF

Answer: A

Free Pass Microsoft  70-461 Final Test -  70-461 Exam Best Study Guide Dumps4download.com