摘要:
/*创建触发器[T_INSERT_卷烟销售表],该触发器较复杂。说明: 每当[卷烟库存表]发生 INSERT 动作,则引发该触发器。触发器功能: 实现业务规则。业务规则: 如果销售的卷烟品牌不存在库存或者库存为零,则返回错误。否则则自动减少[卷烟库存表]中对应品牌卷烟的库存数量和库存金额。*/IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE XTYPE = ’TR’ AND NAME = ’T_INSERT_卷烟销售表’)DROP TRIGGER T_INSERT_卷烟销售表GOCREATE TRIGGER T_INSERT_卷烟销售表ON 卷烟销售表F 阅读全文