Hi
I was going through a lot of post regarding the lock mode set on the row. But didn't get any help and got confused.

Here is my First scenario
1. Thread 1 is reading a row and displaying its data
2. Thread 2 loads that row after some time and read it, copies the row content and delete it So since the entry got deleted it won't be available for display row

Problem:
We have lot of data in the database, and multi-threaded environment so the query we fire fetches 10 records at a time, and after processing is done it fires again
Sometime Thread 2 loads the same row which is going to be deleted

Here is my second scenario
1. Thread 1 is reading a row and displaying its data
2. Thread 2 retrieves the same row and update some fields , which doesn't affect the display of 1st row.

Problem:
We have lot of data in the database, and multi-threaded environent so the query we fire fetches 10 records at a time, and after processing is done it fires again
Sometime Thread 2 loads the same row where the fields has already been updated.

.