
复制CREATE PROCEDURE S2MS.ADDRWDp2 (in inid int,存储
in idend int ) LANGUAGE SQL NOT DETERMINISTIC CALLED ON NULL INPUT MODIFIES SQL DATA INHERIT SPECIAL REGISTERS begin DECLARE rwdid decimal(10,0); declare bh varchar(100); set rwdid=inid; set bh = a; while rwdid<idend do set bh = a||char(rwdid); insert into jtrwd (id,gclb_id,sjdw_id,bh,gcbh,gcmc,wtrq,lxr) values(rwdid,1,1,bh,char(rwdid),gc,current timestamp,d); set rwdidrwdid=rwdid+1; end while; end;> 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.
(责任编辑:系统运维)