sql server 的触发器的demo例子

            --
             =============================================
            --
             Author:        <Author,,Name>
            --
             Create date: <Create Date,,>
            --
             Description:    <Description,,>
            --
             =============================================
            CREATE
            TRIGGER
              TIG_IST_CUT_MTL_TYPE

   
            ON
              CUT_MTL_TYPE

   AFTER  
            insert
            AS
            BEGIN
            --
             SET NOCOUNT ON added to prevent extra result sets from
            --
             interfering with SELECT statements.
            SET NOCOUNT ON;



    DECLARE@new_mtl_type_noVARCHAR(20),

        @max_numINT,

        @IDVARCHAR(500)



    -- Insert statements for trigger hereSELECT@id= id  FROM  inserted 









SELECT@max_num=ISNULL(CAST( REPLACE(MAX(mtl_type_no),‘MT‘,‘‘)  ASINT),0)

FROM   cut_mtl_type

WHERE  mtl_type_no  LIKE‘MT%‘SET@max_num=@max_num+1SET@new_mtl_type_no=‘MT‘+CASEWHEN@max_num>9AND@max_num<=99THEN‘0‘+CAST(@max_numASVARCHAR(10)) 

                      WHEN@max_num>99THENCAST(@max_numASVARCHAR(10)) 

                      ELSE‘00‘+CAST(@max_numASVARCHAR(10)) ENDUPDATE  CUT_MTL_TYPE

    SET  mtl_type_no =@new_mtl_type_noWHERE  id =@idEND