Thursday, April 2, 2009

How is it possible to make sql server query to ignore locked rows ?

Readpast is the sql server 2005 (new) notation, and has the following difference:

NOLOCK would give you the current value of the row, ignoring locks, possibly giving dirty (uncommitted) data

READPAST would only give you only those rows that are not locked and not dirty (only committed) data

No comments: