[求助]????

kao1982215 发布于 2006-09-08 20:27， 457 次点击

工资待遇
提成
最后工资
3个表如何写代码当输入'工资待遇'和'提成'让最后工资自动显示

1 回复

volte2006-09-09 11:49

在存储过程中设置就可以了
create procedure sp_salary
( wage float,
deduct float
)
as
declare
salarysum float
begin transaction
salarysum = wage + deduct;
insert into table
values(wage, deduct, salarysum)
commit transaction
go