Braindump2go Microsoft Exam 70-469 Updated For Free Download(1-15)

QUESTION 1
You use SQL Server 2014 to maintain the data used by applications at your company.
You want to execute two statements.
You need to guarantee that either both statements succeed, or both statements fail together as a batch.
Which code should you use?

clip_image001_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb

 

A.    Option A
B.    Option B
C.    Option C
D.    Option D
E.    Option E

Answer: D
Explanation:
Structure should be:
BEGIN TRY
BEGIN TRANSACTION
..
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
END CATCH.
TRY…CATCH (Transact-SQL)

 

» Read more