摘要：
网摘DELIMITER $$CREATE DEFINER=`root`@`%` PROCEDURE `sp_pament_TrainFee`()BEGIN/*局部变量的定义 declare*/declare strYear int;declare strEnrollID int;declare feesum int;declare stop int default 0;declare cur cursor for(select year ,EnrollID ,sum(Fee) from trainmanage where ReturnStatus !=1 group by Year,Enr.. 阅读全文