Difference Between Row Lock And UpdLock

Folks

Kindly Tell me the Differences between RowLock And UpdLock?

Deep Regards
Anil

Never Give Up

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.

UPDLOCK

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
Anil



Never Give Up