 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / September 2006updlock
select * from employee with (UPDLOCK) where empID = 100 Does this statement lock the entire table or just one record (empID = 100)? > select * from employee with (UPDLOCK) where empID = 100 > > Does this statement lock the entire table or just one record (empID = 100)? By rule it locks all rows "affected". However, it is only a "hint" signalling intent and never a quaranteed lock. For example, another query may have already gained a "lock" on the data. Follow the links at this site... http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1000/en/html/dbwn en10/wn-newjasper-s-3615826.html -ralph |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.