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