Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lesley249
Starting Member
11 Posts |
 Posted - 2008-06-05 : 03:26:21
|
| Hi all,Can anyone help ?What the purpose for this UPDLOCK ROWLOCK ?Will it lock whole table ? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-05 : 03:51:16
|
| The simple answer is No.Rowlock will lock rows as required, updlock will allow read of a row without blocking other readers, but holds a lock until the end of the transaction block so it can not be changed by other users in the meantime. |
 |
|
|
Lesley249
Starting Member
11 Posts |
Posted - 2008-06-08 : 21:33:52
|
| Thanks |
|
|
|
|
|
|
About the Lock