top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the difference between update lock and exclusive lock in SQL Server?

+3 votes
713 views
What is the difference between update lock and exclusive lock in SQL Server?
posted Oct 16, 2015 by Shivaranjini

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

When Exclusive Lock is on any processes no other lock can be placed on that row or table. Every other process have to wait till Exclusive Lock is complete its tasks.

Update Lock is kind of Exclusive Lock except it can be placed on the row which already have Shared Lock on it. Update Lock reads the data of row which has Shared Lock, as soon as Update Lock is ready to change the data it converts itself to Exclusive Lock.

answer Oct 19, 2015 by Manikandan J
...