--出库时
create trigger tr
on A
for delete
as
set xact_abort on
--开始事务
begin tranupdate B
set stockQty=B.stockQty-D.qty
from B
join deleted D on B.invcode=D.invcode
and B.stockWarehouseid=D.wareHouseidcommit tran
go
create trigger tr
on A
for delete
as
set xact_abort on
--开始事务
begin tranupdate B
set stockQty=B.stockQty-D.qty
from B
join deleted D on B.invcode=D.invcode
and B.stockWarehouseid=D.wareHouseidcommit tran
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货