create trigger tr_Sale_MerchInfo
on Sale after insert, update
as
begin
declare @num int
, @MerchID int
select @num = SaleNum, @MerchID = MerchID from inserted
update MerchInfo set MerchNum = MerchNum - @num
where MerchID = @MerchID
end
go
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024