MSSQL - How to Use BEGIN TRAN & COMMIT TRAN

-- roll back automatically when failure occurs

SET XACT_ABORT ON

...

BEGIN TRAN

BEGIN TRY

     ...

     COMMIT TRAN

END TRY

BEGIN CATCH

       ROLLBACK

       RAISERROR ('SQL script failed',16,1)

END CATCH