Re: Theoretical Basis for SELECT FOR UPDATE

vc wrote:
> SELECT FOR UPDATE is not needed for databases with a locking
> concurrency scheduler (SQL Sever, etc) and consequently not
> implemented there.

So why does SQL Server (6.5 up) provide

        SELECT .. FROM tablename (UPDLOCK)
?

It is (as someone else pointed out) useful to avoid some forms of deadlock (due to the promotion of S to X locks). Received on Fri Oct 07 2005 - 00:09:16 CEST