Transaction SQL

Add a try/catch block, if the transaction succeeds it will commit the changes, if the transaction fails the transaction is rolled back:

 BEGIN TRANSACTION [Tran1]  
  BEGIN TRY  
    INSERT INTO [Test].[dbo].[T1] ([Title], [AVG])  
    VALUES ('Tidd130', 130), ('Tidd230', 230)  
    UPDATE [Test].[dbo].[T1]  
    SET [Title] = N'az2' ,[AVG] = 1  
    WHERE [dbo].[T1].[Title] = N'az'  
    COMMIT TRANSACTION [Tran1]  
  END TRY  
  BEGIN CATCH  
    ROLLBACK TRANSACTION [Tran1]  
    SELECT @ErrorMessage = 'Lỗi: ' + ERROR_MESSAGE()
    RAISERROR(@ErrorMessage, 16, 1)
  END CATCH