How to apply Lock on sql table?

Apply Row lock as below

UPDATE
Employees WITH (HOLDLOCK,ROWLOCK)
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

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.