real_yoni wrote:

> Hi,
>
> In SQLServer I can force a select statment to ignore any locks on a
> table (in effect having a shared read on the table).
> SELECT * FROM Items WITH(NOLOCK).
>

As long as you're doing a select (not an insert/update/delete) locks
and your transaction isolation mode is concurrency (aka repeatable
read) or read committed, locks will not apply.


Regards,


Ann