How to apply Lock on sql table?

Question

How to apply lock on table.? or How to Lock perticular row from table?

Ramesh Maruthi · Answer

BEGIN TRAN SELECT * FROM authors WITH (HOLDLOCK ROWLOCK) WHERE au_id = 142 /* Do all your stuff here while the record is locked */ COMMIT TRAN Note: The HOLDLOCK hint will instruct SQL Server to hold the lock until you commit the transaction. The ROWLOCK hint will lock only this record and not issue a page or table lock.

Abhay Shanker · Answer

Apply Row lock as below UPDATE Employees WITH (HOLDLOCKROWLOCK) SET Salary=454545 WHERE Id=3 COMMIT TRAN Check below urls for more detail http://technet.microsoft.com/en-us/library/ms378471(v=sql.110).aspx http://www.sqlteam.com/article/row-locking