Begin Try
  Begin Tran
    DO WORK
  Commit Tran
End Try
Begin CATCH
 SEND ERROR
END CATCH

Begin transaction
-- do some stuff

Begin transaction
-- do some more stuff

Commit transaction

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

USE [MASTER]
BEGIN TRY
       BEGIN TRANSACTION
			Update DBAEmails Set Email = 'thisted@gmail.com' where ID = 2
		COMMIT TRANSACTION
END TRY

BEGIN Catch
       print 'Failure to Update Email'
       RollBack Transaction
End Catch

We walk in the dark places no others will enter
We stand on the bridge and no one may pass