触发器：仓库系统中库存大于零的不能删除

ALTER TRIGGER [sc]
   ON  [dbo].[货品目录]
   AFTER DELETE
AS
declare @R_id char(10),@kc decimal(18, 3)
select @R_id=编号,@kc=当前库存
from deleted
if(@kc>0.0)
BEGIN
 rollback transaction
raiserror('德权:不能删除数据',16,1)
END

 

 

设计简单的Instead Of触发器

CREATE TRIGGER 订单明细_Insert

   ON  订单明细

   Instead Of INSERT

AS

BEGIN

         SET NOCOUNT ON;

         declare

         @订单ID int,

         @产品ID int,

         @单价 money,

         @数量 smallint,

         @折扣 real

         set @订单ID = (select 订单ID from inserted)

         set @产品ID = (select 产品ID from inserted)

         set @单价 = (select 单价 from inserted)

         set @数量 = (select 数量 from inserted)

         set @折扣 = (select 折扣 from inserted)

         if (@折扣)>0.6

                            print '折扣不能大于0.6'

         else

                            INSERT INTO 订单明细

                                     (订单ID,产品ID,单价,数量,折扣)

                            VALUES

                                     (@订单ID,@产品ID,@单价,@数量,@折扣)

         END

GO