触发器 （新增修改）

--新增触发器
CREATE TRIGGER t_insert_itemnumber
on sys_user
for INSERT 
AS 
declare @user_id varchar(50)	
BEGIN	select @user_id=user_id from insertedupdate sys_user set user_app_pwd=123 where user_id = @user_id
END
GO--修改触发器
Create trigger [dbo].[t_update_itemnumber]
on  [dbo].[T_Data_Scales] 
for  update
as 
begin Declare @ID varchar(50)Declare @FName varchar(50)Declare @OldFName varchar(50)--更新前的数据select @OldFName = F_Item from deleted;--更新后的数据SELECT @ID = F_ID,@FName = F_Item FROM insertedIF(@OldFName <> @FName)BEGINupdate T_Data_Scales set F_ItemNumber=(SELECT T.FNUMBER F_ItemValue FROM AIS2021..T_BD_MATERIAL tLEFT JOIN AIS2021..T_BD_MATERIAL_L t1 on t.FMASTERID = t1.FMATERIALIDWHERE t.F_HYKD_CHECKBOX = 1 AND t.FUSEORGID = 100004 AND t1.FName = @FName)WHERE F_ID = @IDEND
end 
GO