触发器，禁止删除某记录

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:        <Author,,Name>

-- Create date: <Create Date,,>

-- Description:    <Description,,>

-- =============================================

ALTER TRIGGER [dbo].[DenyDelete]

   ON  [dbo].[tbsmstemplate]

   for delete

AS 

BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    SET NOCOUNT ON;



    -- Insert statements for trigger here

    if exists (select 1 from deleted where fsmstemplateid in (22,23,24,25))   

    begin   

        RAISERROR ('不能删除id=0的记录', 16, 1)   

        ROLLBACK TRANSACTION   

    end   

END