How to create a lock in SQL Server with T-SQL
You can create a temporary lock in T-SQL for — for example — testing:
BEGIN TRAN
SELECT 1 FROM TABLE WITH (TABLOCKX) WAITFOR DELAY '00:02:00' ROLLBACK TRAN
GO You can create a temporary lock in T-SQL for — for example — testing:
BEGIN TRAN
SELECT 1 FROM TABLE WITH (TABLOCKX) WAITFOR DELAY '00:02:00' ROLLBACK TRAN
GO 