Question

sql insert 触发器（插入时判断）

表1：ICPurchaseEntry
字段： ID ，金额1，辅助金额
要求，插入时，判断当辅助金额不为空时，金额1的数值为辅助金额。
这个触发器如何写？ 谢谢！

Answer 1

create trigger 触发器名 on table ICPurchaseEntry
for insert
as
update ICPurchaseEntry
set 辅助金额 =金额1 where ID in (select ID from inserted) and 辅助金额 is not null
go

Answer 2

update ICPurchaseEntry set 金额1 = 辅助金额
where id in (select id from inserted) and 辅助金额 is not null