Saturday 21 April 2012

Difference Between Implict Transaction And Explict Transaction


Difference Between Implict Transaction And Explict Transaction


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.

No comments:

Post a Comment