rollback OR commit selected operations only

Question

In a transaction block for example i have 5 insert statements:

BEGIN TRANSACTION

Insert A --Should be commited

Insert B

Insert C--Should be commited

Insert D

Insert E

COMMIT TRANSACTION.

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?

---

.Net

Answer 1

Hello,

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.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing