“入库信息”表,建立一个删除触发器,其中的主要处理程序为:
declare @amount
select amount into @amount from deleted
if @amount <= 0 then
delete 入库单 where 入库单.id = deleted.id
declare @amount
select amount into @amount from deleted
if @amount <= 0 then
delete 入库单 where 入库单.id = deleted.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货