| MS SQL locking for update by use of sp getapplock?
We can use sp_getapplock to avoid deadlock or to avoid concurrency. We use the below code to avoid deadlock or concurrency:-
USE DB_Name;
GO
BEGIN TRANSACTION;
DECLARE @result int;
EXEC @result = sp_getapplock @Resource = 'FormName1',@LockMode = 'Shared';
EXEC @result = sp_getapplock @Resource = 'FormName1',@LockMode = 'Exclusive';
EXEC @result = sp_releaseapplock @Resource = 'FormName1';
COMMIT TRANSACTION;
GO
Here in above code we apply lock and then release that and there are two types of locks Shared and Exclusive. | | |