SQL Server——如何锁定一个表直到存储过程结束

I want to do this:

我想这样做:

create procedure A as
  lock table a
  -- do some stuff unrelated to a to prepare to update a
  -- update a
  unlock table a
  return table b
create procedure