SQL Server Performance

Difference Between Row Lock And UpdLock

Discussion in 'General Developer Questions' started by anilsaritha, Jun 8, 2006.

  1. anilsaritha New Member


    Kindly Tell me the Differences between RowLock And UpdLock?

    Deep Regards

    Never Give Up
  2. Madhivanan Moderator

    Read them in sql server help file


    Failing to plan is Planning to fail
  3. anilsaritha New Member

    Dear Madhivanan

    I read it in Sql Server Help File.
    Following Are The Results

    Row Lock

    Use row-level locks instead of the coarser-grained page- and table-level locks.


    Use update locks instead of shared locks while reading a table, and hold locks until the end of the statement or transaction. UPDLOCK has the advantage of allowing you to read data (without blocking other readers) and update it later with the assurance that the data has not changed since you last read it.

    This defintions are not helping me in finding out the difference between the two

    If you have got some other links kindly let me know

    Deep Regards

    Never Give Up
  4. Madhivanan Moderator

  5. FrankKalis Moderator

Share This Page