on 2024 Aug 30 9:42 AM
What is the better approach to synch the update between multiple clients, when each row represents a task:
update first taskstable set P=... where P='' Option(isolation_level = 2)
or
select first ID from taskstable with (UPDLOCK) where P='';
and when doing the update based on ID update taskstable set P=... where ID = ...
or any other suggestions?
Request clarification before answering.
Thanks for the suggestion, I am waiting for my user account on the Forum
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 13 | |
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.