您的建表语句是：
create table aaa
(
id int,
single int,
more int,
total int
)
可以建立一个触发器
create trigger cal_total
on aaa
for insert,update
as
declare @_id as int
declare @_single as int
declare @_more as int
select @_id=i.id,@_single=i.single,@_more=i.more from inserted i
rollback tran
insert into aaa values(@_id,@_single,@_more,@_single+@_more)
测试用例：
insert into aaa values(1,2,3,'')
结果表中出现：
1 2 3 5
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024