Go to DotNetFunda.com
 Welcome, Guest!  
LoginLogin  
{ Submit content and get exposure !!! }
Submit: Article | Interview Question | Tips | Joke | Question | Link || Search  
 Skip Navigation Links Home > Interview/Exam Questions > Difference Between Implict Transaction And Explict Transaction ...


.NET Interview Questions

Difference Between Implict Transaction And Explict Transaction

Author: Majith | Posted on: 7/22/2008 12:54:43 AM | Category: SQL Server | Views:469 |  Print Asked In: Many Interviews





Answer:
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.


Interesting?  Bookmark and Share


Navigate to:

<< Previous Interview Question: Diff Data Grid and Repeater

Next Interview Question >>: What is CAS?

Random Questions: Random Interview Questions

Help: If for some reason you are getting the same question by clicking Next and Previous, Try clicking Random Question or Category link above.


About Us | Contact Us | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
All rights reserved to DotNetFunda.com. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
(Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher)