update emp set sal=sal*(1+0.1) where empno=pempno;
total_sal:=total_sal+psal*0.1;
countemp:=countemp+1;
if total_sal>50000 then
total_sal:=total_sal-psal*0.1;
update emp set sal=sal/1.1 where empno=pempno;
countemp:=countemp-1;
end if;
total_sal:=total_sal+psal*0.1;
countemp:=countemp+1;
if total_sal>50000 then
total_sal:=total_sal-psal*0.1;
update emp set sal=sal/1.1 where empno=pempno;
countemp:=countemp-1;
end if;
2015-12-17
totalsal:=totalsal+psal;
累計方式得到部門總工資的方法,在部門光標里初始化,在員工光標里累加就行,不知道對不對
累計方式得到部門總工資的方法,在部門光標里初始化,在員工光標里累加就行,不知道對不對
2015-12-13