编程基础网 / 编程问答 / 数据库问题 / 正文

在 SQL Server Management Studio (SSMS) 中关闭自动提交

编程基础网数据库问题

2021-01-01

Turn off auto committing in SQL Server Management Studio (SSMS)(在 SQL Server Management Studio (SSMS) 中关闭自动提交)

本文介绍了在 SQL Server Management Studio (SSMS) 中关闭自动提交的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在寻找一个选项来显式提交/回滚在 SSMS 中执行的每个查询，而无需显式启动事务.默认情况下 SSMS 自动提交，没有回滚选项.

解决方案

您可以设置

I’m looking for an option to explicitly commit/rollback every query executed in SSMS without the need to start the transaction explicitly. By default SSMS auto commits leaving no option to rollback.

解决方案

You can SET IMPLICIT_TRANSACTIONS ON in a query window.

If you set this in the Query/Query Options menu it will be set just for the current query. If you set this in the Tools/Options/Query Execution/SQL Server/ANSI menu it will be the default for all new queries.

这篇关于在 SQL Server Management Studio (SSMS) 中关闭自动提交的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！

编程基础网

本文标题为：在 SQL Server Management Studio (SSMS) 中关闭自动提交