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 |
|
chetanb3
Yak Posting Veteran
52 Posts |
 Posted - 2008-06-23 : 09:19:48
|
| can anybody explain following query.SELECT * FROM TABLE1 e WITH (UPDLOCK)JOIN TABLE@ i ON Id=Id |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-23 : 09:26:19
|
UPDLOCK is explained in Books Online, the SQL Server help file.Please post which pages you have read and didn't understand and we maight be able to help you further.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-23 : 09:28:50
|
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/8bf1316f-c0ef-49d0-90a7-3946bc8e7a89.htm
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
update lock