SQLSERVER触发器

--在Goods表建立删除触发器﹐实现Goods表和Orders表的级联删除。 create trigger goodsdelete on Goods after delete as begin delete from orders where goddsname in (select [name] from deleted) end --判断状态是否为1 如果为1 则正在处理 create trigger orderinsert on orders after insert as begin if(select status from goods as inserted where goods.[Name]=inserted.goodsname)=1 print 'process.....' rollback transaction end --在orders表建立一个插入触发器 添加一个订单时 减少表Goods库存量减一 create trigger orderinsert on orders after insert as begin update goods set storage=storage-inserted.quantity from Goods as inserted where goods.name=inserted.goodsname; end

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!