Tuesday, March 06, 2012 5:09 AM
In a transaction block for example i have 5 insert statements:
Insert A --Should be commited
Insert C--Should be commited
Now let's suppose, statement E got failed, and while rolling back the whole bunch of statements, I want statement A and C to be commit ed. Is it possible?
- Edited by Priyank Kansal Tuesday, March 06, 2012 5:09 AM
Tuesday, March 06, 2012 5:55 AM
No, that's not possible in this way. You can commit every changes done within a transaction or rollback everything, bit you can't commit particular operations. In case of a rollback you could only redo this operations, but then you could do them already outside the transaction instead of within it.
- Marked As Answer by KJian_ Monday, March 12, 2012 6:37 AM