Post reply

Get number of rows successfully processed before executing a rollback

  • February 18, 2014 at 2:05 am

    #282578

    Hi folks,

    is there any way to get the number of rows successfully processed before executing a rollback?

    suppose i am having three different SP's all three is having transaction and updating different tables. if one of the update failed in any inner SP can i keep the track of number of successful updates and start from there instead of updating all the process again.

    thanks in advanced

    Ghanshyam

  • February 18, 2014 at 2:53 am

    #1689782

    ghanshyam.kundu (2/18/2014)

    Hi folks,

    is there any way to get the number of rows successfully processed before executing a rollback?

    suppose i am having three different SP's all three is having transaction and updating different tables. if one of the update failed in any inner SP can i keep the track of number of successful updates and start from there instead of updating all the process again.

    thanks in advanced

    Ghanshyam

    Kind of convoluted question...

    It's really depends on what exactly your design is.

    If your three different SP's are part of the the same transaction - then answer is NO: Rollback in any of them will cause rollback of the whole transaction.

    If these SP's do open independent transaction, then it is possible.

    If you process something in batches, then you can wrap the single batch into own transaction and then you can start after the failure from kind of point of failure.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply