Mark Baldwin
3/29/2007 3:30:00 PM
yes it does lock when you do a SELECT but it's a kind of read only lock
which is compatible with other read only locks (so more than 1 person can
SELECT at a time) but is incompatible with a write lock, so if someone
updates each row in a table causing a table lock, other users won't be able
to select from it, of course its much more complicated than this, you can
control locking behaviour with isolation levels, indexes and sturcture of
your queries.
--
Best regards
Mark
"Roy Goldhammer" <roy@hotmail.com> wrote in message
news:edC%23lOhcHHA.4308@TK2MSFTNGP02.phx.gbl...
> Hello there
>
> when i run Select statment on entire table. Does the table locked for
> other uses even for select part of the table?
>
> and when i run select statnent on part of the table. Does only that part
> is locked even for select?
>