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 |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2009-08-12 : 03:20:26
|
| Hi,Is It advisable to use updlock for update statements. I beleive update statement will default hold a lock until the transaction completes.Please advice |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-08-12 : 10:36:03
|
| here is a very nice article on locking:http://www.sqlteam.com/article/introduction-to-locking-in-sql-serverGenerally speaking, a simple UPDATE statement which is not part of a multi-statement user transaction does not require any locking hints beyond the default settings. Are you trying to solve a specific problem? If so, what is it?Be One with the OptimizerTG |
 |
|
|
|
|
|
UPDLOCK