7
Reply

What is the difference between implicit and explicit transaction?

Kumar Bhimsen

Kumar Bhimsen

Jan 08, 2016
4.1k
0

    1. Implicit transaction is auto commit, there are no beginning and ending of the transaction while explicit transaction has beginning and end and rollback command. 2. In explicit transaction, if error occurs between transaction then it can be roll back where as it is not possible in implicit transaction.

    Kumar Bhimsen
    January 08, 2016
    1

    In Implicit you don't have any option to Rollback your data. and In Explicit you have a control to Rollback you required data. and also you can use Save point to Rollback desired data.

    Sandeep Singh
    August 19, 2016
    0

    Right.

    Vishal Jadav
    August 15, 2016
    0

    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.

    Keerthi Venkatesan
    June 08, 2016
    0

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

    Munesh Sharma
    May 09, 2016
    0

    Implicit means automatic transaction by system and explicit means we need to write some code for do it

    Amit Parmar
    March 11, 2016
    0

    Explicit transaction - each singular statement is immediately committed Implicit transaction - transaction is open until a commit is issued. If no commit is issues then implicit rollback is issued

    Shweta Lodha
    January 21, 2016
    0