Microsoft
70-457 · Question #86
You use Microsoft SQL Server 2012 to develop a database application. You create a stored procedure named dbo.ModifyData that can modify rows. You need to ensure that when the transaction fails…
The correct answer is D. BEGIN TRANSACTION. See the full explanation below for the reasoning.
Question
You use Microsoft SQL Server 2012 to develop a database application. You create a stored procedure named dbo.ModifyData that can modify rows. You need to ensure that when the transaction fails, dbo.ModifyData meets the following requirements:
- Does not return an error
- Closes all opened transactions
Which Transact-SQL statement should you use?
Options
- ABEGIN TRANSACTION
- BBEGIN TRANSACTION
- CBEGIN TRANSACTION
- DBEGIN TRANSACTION
How the community answered
(61 responses)- A10% (6)
- B2% (1)
- C7% (4)
- D82% (50)
Community Discussion
No community discussion yet for this question.