34,594
社区成员
发帖
与我相关
我的任务
分享
create trigger tri_g
on 表
for update
as
begin
update 系统_操作员 set... from inserted a
end
create trigger ARMtrigger
on AccountReceivableMaster
after update
as
update AccountReceivableMaster
set UnAccountReceivable=
isnull(AccountReceivableAmount,0)-isnULL(DoAccountReceivableAmount,0) from inserted where inserted.InvoiceNO=AccountReceivableMaster.InvoiceNO
create trigger ARMtrigger
on AccountReceivableMaster
after update
as
update AccountReceivableMaster
set UnAccountReceivable=
isnull(AccountReceivableAmount,0)-isnLL(DoAccountReceivableAmount,0) from inserted
--试试
create trigger 名称 on 表
for insert,update
as
begin
...end