cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Update with isolation_level vs. select with lock

MCMartin
Participant
0 Likes
634

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

MCMartin
Participant
0 Likes

Thanks for the suggestion, I am waiting for my user account on the Forum