Sqlserver disables automatic transaction submission of management studio

Automatically submit transactions

By default, management studio automatically submits transactions, that is, one statement is a transaction.

Implicit transactions

Open SQL Server Managerment Studio and log on to the instance.
Tools-> Options
Query Execution-> SQL Server-> ANSI

Check SET IMPLICIT_TRANSACTIONS
In this way, when a transaction ends, the new statement will automatically start a new transaction. This is an implicit transaction. The transaction is finally ended through our commit or rollback.

Explicit transactions

Begin transaction
Delete from erpdb. dbo. mtl_categories_ B
Rollback transaction
-- Commit transaction