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

文章/答案/技术大牛

发布

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

推荐文章

重感情的大象 · Mysql中autocommit的用法 - 三国梦回

3 周前

痴情的冲锋衣 · 聊一聊 .NET高级调试中的一些内存术语-腾讯云开发者社区-腾讯云

7 月前

力能扛鼎的冰棍 · IIS日志_百度百科

12 月前

小眼睛的苹果 · c# tcpclient send and receive data-掘金

1 年前

打盹的大熊猫 · java 调用python 数组传递_mob649e8160b585的技术博客_51CTO博客

1 年前

老实的草稿本 · vs调用堆栈窗口怎么弄出来-掘金

1 年前

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

Stack Overflow用户