Sunday, 17 January 2016

NoLock & NoWait in sql server

NOWAIT will return error if the original table has (transaction) locked on it.

NOLOCK will read the data irrespective of the (transaction) lock on it.

No comments:

Post a Comment