Autocommit Transactions

Question

Autocommit Transactions

Steve Jones - SSC Editor

SSC Guru

Points: 736162
More actions
October 17, 2022 at 12:00 am

#4097607

Comments posted to this topic are about the item Autocommit Transactions

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

johnk 38614 Old Hand Points: 311 More actions · Answer 1

In the implicit transaction mode, SQL Server takes the responsibility for beginning the transactions implicitly but it waits for the commit or rollback commands from the user.

Therefor Answer A is not the case

Piotr ER SSCertifiable Points: 5578 More actions · Answer 2

I would buy explanation given here if it wasn't supported by ms docs link which says

Implicit transactions
A new transaction is implicitly started when the prior transaction completes, but each transaction is explicitly completed with a COMMIT or ROLLBACK statement.

and

Autocommit transactions
Each individual statement is a transaction.

So, in autocommit mode transactions for dml will be implicitly opened and closed but they are not "implicit transactions" which (since implicit mode was introduced) have to be explicitly closed.

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 3

The question has been adjusted. My mistake for miswording things.