Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What are the differences between lock types which are: share mode share update mode exclusive mode

user-image
Question ajoutée par Abdullah Bajaber , ERP Supervisor and Business Analysis , 3D vision
Date de publication: 2014/09/08
Muhammad Waqas
par Muhammad Waqas , C#/.Net Developer , Signup solution

Shared(S):Used for read operations that do not change or update data, such as a SELECT statement.

Update(U):Used on resources that can be updated. Prevents a common form of deadlock that occurs when multiple sessions are reading, locking, and potentially updating resources later.

Exclusive(X):Used for data-modification operations, such as INSERT, UPDATE, or DELETE. Ensures that multiple updates cannot be made to the same resource at the same time.

More Questions Like This