“嵌套”事务，为什么会发生这种情况，我如何避免它？开发者社区

文章/答案/技术大牛

发布

CREATE PROCEDURE [inner] AS BEGIN
    SET XACT_ABORT, NOCOUNT ON;
    BEGIN TRY
        BEGIN TRANSACTION;
        IF (1 + 1 = 2) BEGIN
            ROLLBACK TRANSACTION;
        END ELSE BEGIN
            COMMIT TRANSACTION;
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0 BEGIN
            ROLLBACK TRANSACTION;
    END CATCH
END

CREATE PROCEDURE [outer] AS BEGIN
    SET XACT_ABORT, NOCOUNT ON;
    BEGIN TRY
        BEGIN TRANSACTION;
        EXEC [inner];
        COMMIT TRANSACTION;
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0 BEGIN
            ROLLBACK TRANSACTION;
        ;THROW;
    END CATCH
END

EXEC [outer];

Msg 266 Level 16 State 2 Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements.
Previous count = 1, current count = 0.

CREATE PROCEDURE [inner] AS BEGIN
    SET XACT_ABORT, NOCOUNT ON;
    BEGIN TRY
        DECLARE @tranCount int = @@TRANCOUNT;
        IF @tranCount = 0
            BEGIN TRANSACTION;
        SAVE TRANSACTION innerSave;
        IF (1 + 1 = 2) BEGIN
            IF @tranCount = 0
                ROLLBACK;
                ROLLBACK TRANSACTION innerSave;
        END ELSE BEGIN
            COMMIT TRANSACTION;
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0 BEGIN
            IF @tranCount = 0

推荐文章

伤情的热水瓶 · 关于RSA加解密的异常 javax.crypto.BadPaddingException: block incorrect-CSDN博客

1 月前

旅行中的闹钟 · zting科技_高分内容_个人页_第15页_阿里云开发者社区

1 年前

茫然的显示器 · ExcelHelper 通用类 - bin790302901 - 博客园

1 年前

闯红灯的马克杯 · $ - 字符串内插 - 格式字符串输出 | Microsoft Learn

1 年前

耍酷的黑框眼镜 · vue 在浏览器的控制台打印变量 - 掘金

1 年前

问 “嵌套”事务，为什么会发生这种情况，我如何避免它？ EN

Stack Overflow用户