可它的承诺，并连接关闭后的事务回滚？ [英] Can a transaction be rolled back after it's committed and connection is closed?

问题描述

能否事务中它的承诺，并连接关闭后回滚？

Can a transaction be rolled back after it's committed and connection is closed?

    finally
    {
        // Commit the transaction.
        sqlTran.Commit();

        reader.Close();
        reader.Dispose();

        conn.Close();
        conn.Dispose();
    }

我想给用户的哎呀的选择！回滚的。所以，如果它的COMMITED能不能回滚？

I would like to give the user an option of Opps! roll it back. So if it's commited can it be rolled back?

推荐答案

一个提交的事务永远不能，如果你希望你的交易将回滚持续的提交后。

A committed transaction can never be rolled back if you want your transaction to be persistent after a commit.

您是否正在寻找的保存点？

这篇关于可它的承诺，并连接关闭后的事务回滚？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！