SQL Server Performance Forum – Threads Archive
Difference Between Row Lock And UpdLock
Folks Kindly Tell me the Differences between RowLock And UpdLock? Deep RegardsAnil Never Give Up
Read them in sql server help file Madhivanan Failing to plan is Planning to fail
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
See if this helps
http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm Madhivanan Failing to plan is Planning to fail
You’ve picked the wrong passage from BOL. Search for "Understanding Locking in SQL Server". This is likely to explain better. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
]]>