Post reply

HOLDLOCK along with UPDLOCK

  • January 10, 2013 at 10:32 am

    #393919

    Hi,

    Using either HOLDLOCK or UPDLOCK as a lock hint allows other transactions to see the data, but, when used together, the other transactions cannot see the data until the previous transaction is completed.

    Can anyone shed some light on what happens when these locks are used together, and what happens.

    Thanks.

  • January 10, 2013 at 11:53 am

    #1575916

    The update lock is held until the transaction commits or rolls back.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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