By default, managementstudio automatically commits a transaction, that is, one statement is a transaction. Open SqlServerManagermentStudio for implicit transactions and log on to the instance. Tools
By default, management studio automatically submits transactions, that is, one statement is a transaction. Open SQL Server Managerment Studio for implicit transactions and log on to the instance. Tools-OptionsQuery Execution-SQL Server-ANSI checks before SET IMPLICIT_TRANSACTIONS. When a transaction ends
By default, management studio automatically submits transactions, that is, one statement is a transaction.
Open SQL Server Managerment Studio for implicit transactions and log on to the instance. Tools-> OptionsQuery Execution-> SQL Server-> ANSI checks before SET IMPLICIT_TRANSACTIONS. When a transaction ends, the new statement automatically starts a new transaction. This is an implicit transaction. The transaction is finally ended through our commit or rollback.
Explicit transaction begin transactiondelete from erpdb. dbo. mtl_categories_brollback transaction -- commit transaction
