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 |
|
Adarshask
Starting Member
3 Posts |
 Posted - 2009-10-26 : 02:50:13
|
| If some process P1 has locked a record R1 of Table T1 using select for update, then if some other process P2 comes and checks for record selection, how to make the other process P2 to wait until the first process P1 releases the lock(via COMMIT/ROLLBACK)?Thanks in advance,Adarsh.S.K |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Unlocking Rows - SELECT FOR UPDATE