Sql语法高级应用之七：如何在存储过程中使用事务

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 TRANSA