SQLSERVER触发器中带提示的例子

ALTER TRIGGER [dbo].[ICStockBill_DEL]
            ON [dbo].[ICStockBill]
FOR DELETE
AS
    SET NOCOUNT ON
    
    IF EXISTS (SELECT 1 FROM DELETED WHERE FCheckerID <> 0)
    BEGIN
        ROLLBACK TRAN
        RAISERROR('不能删除已经审核的单据!',18,18)
    END
    ELSE IF EXISTS (SELECT 1 FROM DELETED WHERE FCancellation = 1)
    BEGIN
        ROLLBACK TRAN
        RAISERROR('不能删除已经作废的单据!',18,18)
    END
    ELSE
        DELETE E
          FROM ICStockBillEntry E
               INNER JOIN deleted D ON E.FInterID = D.FInterID