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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 About the Lock

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.
Go to Top of Page

Lesley249
Starting Member

11 Posts

Posted - 2008-06-08 : 21:33:52
Thanks
Go to Top of Page
   

- Advertisement -