READ Free Dumps For Microsoft- 70-461
| Question ID 15084 | 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?
|
Explanation
| Question ID 15085 | 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?
|
| Option A | SET XACT_ABORT ON
|
| Option B | SET ARITHABORT ON
|
| Option C | TRY
|
| Option D | BEGIN
|
| Option E | SET ARITHABORT OFF
|
| Option F | SET XACT_ABORT OFF
|
| Correct Answer | A |
Explanation Reference: http://msdn.microsoft.com/en-us/library/ms190306.aspx Reference: http://msdn.microsoft.com/en-us/library/ms188792.aspx