Differences Between Implicit Transaction And Explicit Transaction

Question

Hi What are Differences Between Implicit Transaction And Explicit Transaction ?

Munesh Sharma · Answer

http://sqltouch.blogspot.in/2013/05/writelog-waittype-implicit-vs-explicit.html

Satyapriya Nayak · Answer

Hi Arun Implicit Transaction is the auto commit. There is no beginning or ending of the transaction. Explicit Transaction has the beginning ending and rollback of transactions with the command Begin Transaction Commit Transaction and Rollback Transation In the explicit transaction if an error occurs in between we can rollback to the begining of the transaction which cannot be done in implicit transaction. Thanks