Oh dear horrible Answers
Nolock is a table hint , which request to query optimizer the get me the data and i don`t care if any operation
(delete update insert) happening on this table. and allow dirty reading,
so what data you get with the nolock might not be consistent.
its a request only to query optimizer, In some cases query optimizer does`t look at what hint you submitted.
By default database isolation is Read committed that means if any (delete update insert) then do not select the data from the objects if locked.
here i refereed objects not table because if indexed are on the table the query optimizer look data in the index
Visit my blog
Nadh123, if this helps please login to Mark As Answer. | Alert Moderator