Home Forums SQL Server 2008 SQL Server 2008 - General Record locking RE: Record locking
JohnPapa
Mr or Mrs. 500
Points: 553
More actions
January 3, 2013 at 9:41 am
#1573393
After some more read maybe this would lock a record (and only one record) until all work is done,
BEGIN TRAN
SELECT * FROM tblName WITH (HOLDLOCK, ROWLOCK)
WHERE ID = someID
/* While the record is locked do work*/
COMMIT TRAN