SELECT FOR UPDATE NO WAIT in SQL Server ?

[Parvinder Singh Arora]

Hi,

Is SQL Server having any parallel construct for SELECT FOR UPDATE NO
WAIT kind of clause which exists in oracle ?

Thanks & Regards
~Parvinder

[Parvinder Singh Arora]

I got the answer to this question of mine
Select query with UPDLOCK & READPAST option

UPDLOCK
Specifies that update locks instead of shared locks are taken while
reading the table, and that they are held until the end-of-statement
or end-of-transaction.

READPAST

Specifies that locked rows are skipped (read past). For example,
assume table T1 contains a single integer column with the values of 1,
2, 3, 4, 5. If transaction A changes the value of 3 to 8 but has not
yet committed, a SELECT * FROM T1 (READPAST) yields values 1, 2, 4, 5.
READPAST applies only to transactions operating at READ COMMITTED
isolation and reads past only row-level locks. This lock hint is used
primarily to implement a work queue on a SQL Server table.

~Parvinder

minku...@yahoo.com (Parvinder Singh Arora) wrote in message news:<e7c950a4.02030...@posting.google.com>...