Stored procedure: how to update multiple tables, how to avoid database lock, how to return multline table

Yes.There is a resultset from the select statement from the SELECT stored procedure. Design your stored procedure to do separate things for easy management.