Hi All,
I would like to know what happens when a user tries to fetch a record in NO-LOCK which is being modified by another user at the same time but not been comitted till then? In other words, whether the user who wants to read that record will get a record which is not logically consistent or he will get the previously comitted data?
Thanks.
Subhansu
I would like to know what happens when a user tries to fetch a record in NO-LOCK which is being modified by another user at the same time but not been comitted till then? In other words, whether the user who wants to read that record will get a record which is not logically consistent or he will get the previously comitted data?
Thanks.
Subhansu