There are three main types of locks in SQL Server:
(1)Shared locks
used for operations that does not allow to change or update data, such as a SELECT statement.
(2)Update locks
used when SQL Server intends to modify a page, and later promotes the update page lock to an exclusive page lock before actually making the changes.
(3)Exclusive locks
used for the data modification operations, such as UPDATE, INSERT, or DELETE.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|