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

在存储过程中设置就可以了
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