atomicity of locking in select from multiple tables case

Giganews Newsgroups
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
etc...

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
available.

Thanks in advance.

Replies