|Subject:||atomicity of locking in select from multiple tables case|
|Posted by:||migurus (migur…@yahoo.com)|
|Date:||Wed, 13 Oct 2010|
SQL 2005, my connection is under default READ COMMITED level.
I'd like to know whether locks are placed atomically when I say:
select T1.Col1, T2.Col2 from TBL1 T1, TBL2 T2 where T1.Key=T2.Key
In other words, does db acquire locks for resources T1 and T2
atomically (all or none), or there is a possibility that it would
acquire lock on T1 resource and wait for T2 resource to become
Thanks in advance.