CODEWITHSUNDEEP
sqllockingsql-server-2000nolock
aepheus
aepheus

Reputation: 8197

with nolock and exclusive locks

So, with nolock will not take any locks. Will it still honor outstanding locks? For example, if I attempt to select a row with nolock, which another process has put an exclusive lock on, will my select with nolock be blocked, or will it select the row?

Upvotes: 1

Views: 549

Answers (1)

Praveen
Praveen

Reputation: 1449

I think the use of "NOLOCK" results in a dirty read which means that the data which is present before some locking has happened. Suppose, if a write lock has been put on a table to update some data and we try to read the data using "NOLOCK", the data which is present before updating is returned to us.

Hope this helps!!

Upvotes: 1

Related Questions