TiMa

分类: B1

  • B1 禁止删除报表触发器

    create trigger [dbo].[BBKZ] ON [dbo].[OUQR]

    instead of  update

    AS

    DECLARE @FirstTest VARCHAR(1000)

    DECLARE @LastTest VARCHAR(1000)

    SELECT @FirstTest=convert(varchar(1000),QString)  FROM deleted

    SELECT @LastTest= convert(varchar(1000),QString) FROM inserted

    IF @FirstTest IS NOT NULL AND @LastTest =””

    BEGIN

    raiserror(‘  不允许删除报表’,16,8)

    rollback

    END