0

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 ?

Edited by pritaeas: Moved.

2
Contributors
2
Replies
4
Views
4 Years
Discussion Span
Last Post by HunainHafeez
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.