Post reply

Perform an update but skip lock

  • March 10, 2014 at 8:02 am

    #1695533

    I see the Cursor word.

    Getting to the core of the locks might be best.

    Skipping over locked records, unless you get back to them, you likely did not do what you expected with the data.

    As mentioned before, there are some very good reasons for locking.

  • March 10, 2014 at 9:35 am

    #1695587

    I think this conversation might best start with WHY you want to do this.

    Updating all records but locked ones is a weird requirement. You'll have to update the locked ones eventually, right?

    Also asking why you have another transaction that is locking rows for so long you want to skip them may be helpful thing.

    It just kinda sounds like you are trying to work around a larger problem by doing this, and may be creating more headaches for yourself in doing so.

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

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