Question:
How can I lock a row in a table from a stored procedure?
Answer:
You shouldn’t have to worry about locking. It’s done automatically by the engine when you do an update or insert. You can control to what extent the locking occurs by setting you isolation level.