Difference Between Implict Transaction And Explict Transaction

 Posted by Majith on 7/22/2008 | Category: Sql Server Interview questions | Views: 12433

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.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response