Sql存储过程基础

时间:2019-07-09 14:54:26   收藏:0   阅读:108

BEGIN
DECLARE _zhiGongID VARCHAR(25);
DECLARE _zhiGongGH VARCHAR(25);
DECLARE _zhiGongXM VARCHAR(25);
#定义游标,并将sql结果集赋值到游标中
DECLARE num INT DEFAULT 0;
#定义游标,并将sql结果集赋值到游标中
DECLARE jsyh_list CURSOR FOR SELECT ZhiGongID,ZhiGongGH,ZhiGongXM FROM cmp_sys.rms_jueseyh where ID < 10;
#当游标遍历完成后,该改变游标标志值
DECLARE CONTINUE HANDLER FOR NOT FOUND SET num = 1;
OPEN jsyh_list;
#按结果集顺序赋值变量
FETCH jsyh_list INTO _zhiGongID,_zhiGongGH,_zhiGongXM;

WHILE num <> 1 DO
INSERT INTO cmp_sys.rms_khjlambxx(ZhiGongID,ZhiGongGH,ZhiGongXM) VALUES(_zhiGongID,_zhiGongGH,_zhiGongXM);
FETCH jsyh_list INTO _zhiGongID,_zhiGongGH,_zhiGongXM;
END WHILE;
CLOSE jsyh_list;
END

原文:https://www.cnblogs.com/pingfandeyisheng/p/11156958.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!