if i have table in database(sql server) and has 1500 records and i run 2 applications(at same time) that will retrieve 500 records each so how can i do this

app1 will retrieve first 500 records
app2 will retrieve next 500 records means no over lap

SET Transaction Isolation Level Read committed not working for me

note: actually my app have one db and many client apps so (running 1 or more at a time) while reading records from DB i have to lock those rows so that it can't be read by others' requests and after that i will update status. question is how can i LOCK rows while reading ?

i used Microsoft Queue for keeping cache of records as a thread in MS queue :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.