xxxxxxxxxx
-- Shared lock mode (S)
SELECT * FROM table_name WITH (TABLOCKX, HOLDLOCK)
-- Update lock mode (U)
UPDATE table_name SET column_name = 'new_value' WHERE condition
-- Exclusive lock mode (X)
DELETE FROM table_name WHERE condition
xxxxxxxxxx
Available locks (SQL Server):
Exclusive (X)
Shared (S)
Update (U)
Intent (I)
Schema (Sch)
Bulk update (BU)