Now I can write the separate stored procedure.
-- get the total query id result
select id from book where bookprice>10;
-- only pass a single id
call sp_refreshbook(id);
How to merge them together?now I want to search the id result and them call the sp_refreshbook
in each id in the result in a new store stored procedure.
I have solve this problem using cursor by myself.