可以设在公式里如果要触发器
create trigger I_a on a
instead of insert
as
set nocount on
update a set c = a-b
where 主键 in (select 主键 from inserted)
create trigger I_a on a
instead of insert
as
set nocount on
update a set c = a-b
where 主键 in (select 主键 from inserted)
create trigger I_a on a
for insert
as
set nocount on
update a set c = a.a-a.b from inserted where a.主键=inserted.主键
go