如何在 SQL Server 会话中设置自动提交? [英] How do you set autocommit in an SQL Server session?

问题描述

如何在 SQL Server 会话中设置自动提交?

How do you set autocommit in an SQL Server session?

推荐答案

你可以通过设置implicit_transactions OFF来开启自动提交:

You can turn autocommit ON by setting implicit_transactions OFF:

SET IMPLICIT_TRANSACTIONS OFF

当设置为 ON 时，它返回到隐式事务模式.在隐式事务模式下，您所做的每一次更改都会启动一个您必须手动提交的事务.

When the setting is ON, it returns to implicit transaction mode. In implicit transaction mode, every change you make starts a transactions which you have to commit manually.

也许举个例子更清楚.这会将更改写入数据库:

Maybe an example is clearer. This will write a change to the database:

SET IMPLICIT_TRANSACTIONS ON
UPDATE MyTable SET MyField = 1 WHERE MyId = 1
COMMIT TRANSACTION

这不会将更改写入数据库:

This will not write a change to the database:

SET IMPLICIT_TRANSACTIONS ON
UPDATE MyTable SET MyField = 1 WHERE MyId = 1
ROLLBACK TRANSACTION

以下示例将更新一行，然后抱怨没有要提交的事务:

The following example will update a row, and then complain that there's no transaction to commit:

SET IMPLICIT_TRANSACTIONS OFF
UPDATE MyTable SET MyField = 1 WHERE MyId = 1
ROLLBACK TRANSACTION

就像 Mitch Wheat 所说的，自动提交是 Sql Server 2000 及更高版本的默认设置.

Like Mitch Wheat said, autocommit is the default for Sql Server 2000 and up.

这篇关于如何在 SQL Server 会话中设置自动提交?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！