sqlserver 触发器（建在表下面的）案列

原创

晴天MZ 2023-02-28 15:56:10 博主文章分类：sqlServer ©著作权

©著作权归作者所有：来自51CTO博客作者晴天MZ的原创作品，请联系作者获取转载授权，否则将追究法律责任

USE [easdata]
GO
/****** Object:  Trigger [dbo].[t_con_projectstart_upd]    Script Date: 2019/2/19 22:39:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
  ALTER  TRIGGER   [dbo].[t_con_projectstart_upd]   ON    [dbo].[T_CON_ProjectStart]
FOR  UPDATE
as
BEGIN
    IF  UPDATE (FBillStatus)
    begin
        DECLARE  @FID    NVARCHAR( 255),@status   nvarchar( 10),@oldstatus   nvarchar( 10), @Fnumber  NVARCHAR( 255),
     @fprojectcode NVARCHAR( 255),@fpersonid NVARCHAR( 255),@FCreatorID NVARCHAR( 255)
        select  @FID =FID, @status =fbillstatus ,@fprojectcode=fprojectcode,@FCreatorID =FCreatorID   FROM  inserted 
    select @fpersonid =fpersonid from T_PM_User where fid = @FCreatorID
      if (@status ='1')  
        if not exists(select fnumber from T_BD_Project where fnumber = @fprojectcode)
  insert into T_BD_Project(
    fid,
    fname_l2,fnumber,fisleaf,flevel,flongnumber,ftype,fstatus,FScheduleStartDate,FSchedulEndDate,
        FCreatorID,FCreateTime,
        FLastUpdateUserID,FLastUpdateTime,
        FControlUnitID,FDisplayName_L2,FIsListItem,
        FCompanyID,FIsSysCreate,fisprostart,FPrjManagerID
        )
    select 
       [dbo].[newbosid]('DADE05EE') newfid,
     fprojectname,fprojectcode,1 fisleaf,1 flevel,fprojectcode,0 ftype,1 fstatus,fstartdate,fenddate,
       FCreatorID,FCreateTime,
     FLastUpdateUserID,FLastUpdateTime,
     FControlUnitID,fprojectname,1 FIsListItem,
     FControlUnitID,0 FIsSysCreate,1 fisprostart, @fpersonid
  FROM t_con_projectstart where fid =@fid;
  END;
END