摘要： BEGINdeclare newprodid int;declare stock int ;declare total int;declare warehouse_stock_num int;declare prod_stock_num int;declare cursor_test CURSOR FOR SELECT product_id,stock_quantity_bh FROM ProductPage.product_stock where stock_quantity_bh>0;select count(product_id) into prod_stock_num from 阅读全文