Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to understand the automatic commit transaction of management studio prohibited by sqlserver. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Auto commit transaction the default management studio is to automatically commit a transaction, that is, one statement for one transaction. The implicit transaction opens the Sql Server Managerment Studio and logs in to the instance. Tools-> Options Query Execution-> SQL Server-> ANSI ticks before SET IMPLICIT_TRANSACTIONS so that when a transaction ends, the new statement automatically opens a new transaction. This is an implicit transaction. The transaction also ends up through our commit or rollback. Explicit transaction begin transaction delete from erpdb.dbo.mtl_categories_b rollback transaction-- commit transaction

On how to understand how sqlserver forbids management studio autocommit transactions to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.