- 论坛徽章:
- 1
|
本帖最后由 y331044508 于 2011-10-10 17:30 编辑
informix 版本:15.6- 创建table3
- CREATE TABLE table3
- (
- yjid integer PRIMARY KEY,
- mustyj float,
- realityyj float,
- percentyj float
- );
- insert into table3 (yjid,mustyj,realityyj,percentyj) values ('1','10','8.9','');
- insert into table3 (yjid,mustyj,realityyj,percentyj) values ('2','10','7.9','');
- insert into table3 (yjid,mustyj,realityyj,percentyj) values ('3','10','8.4','');
- insert into table3 (yjid,mustyj,realityyj,percentyj) values ('4','10','8.3','');
- insert into table3 (yjid,mustyj,realityyj,percentyj) values ('5','10','7.3','');
- --6、计算员工的业绩百分比
- drop procedure table_function;
- create procedure table_function()
- yjid_v integer;
- mustyj_v float;
- realityyj_v float;
- percentyj_v float;
- let percentyj_v =''
- while percentyj_v =''
- select first 1 yjid,mustyj,realityyj,percentyj into yjid_v,mustyj_v,realityyj_v,percentyj_v from table3 where percentyj='';
- --计算出realityyj_v / mustyj_v = percentyj_v 这里如何写?
- updata table2 set percentyj=percentyj_v where yjid=yjid_v;
- end while;
- end procedure;
复制代码 刚开始学习这个,还希望前辈们多多指教,看看我这个存储写的是不是不够简洁。
再是希望能够给我说下具体的存储过程中如何使用运算符,谢谢。 |
|