USE Wot_Inventory;

GO

BEGIN TRANSACTION tr;

DECLARE @error INT;

SET @error = 0;

SELECT * FROM Wot_Inventory.dbo.Logistics;

SET @error = @error + @@ERROR;

SELECT 1 / 0;

SET @error = @error + @@ERROR;

SELECT * FROM Wot_Inventory.dbo.Invoice;

SET @error = @error + @@ERROR;

PRINT 'i have executed!';

SET @error = @error + @@ERROR;

PRINT '@@error:' + CAST(@error AS VARCHAR(50));

IF (@error <> 0)

BEGIN

    PRINT 'executed failed';

    ROLLBACK TRANSACTION tr;

END;

ELSE

BEGIN

    PRINT 'executed success';

    COMMIT TRANSACTION tr;

END;

USE Wot_Inventory;

GO

BEGIN TRY

    BEGIN TRANSACTION tr;

    UPDATE dbo.Logistics SET EngFlag = 1 WHERE LogisticCode = '620752867926';

    SELECT 1 / 0;

    PRINT 'i have executed!';

    SELECT * FROM dbo.Logistics;

    PRINT 'executed success';

    COMMIT TRANSACTION tr;

END TRY

BEGIN CATCH

    PRINT 'executed failed';

    ROLLBACK TRANSACTION tr;

END CATCH;