row level locking

How to realize row level locking when updating table .?You can confirm it from SQL Query analyzer by executing procedure sp_lock. Execute sp_lock whenever you want to check locks after a particular query to some database.|||sp_indexoption