create trigger TRT_Insert
ON 表名1
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
Declare @ID int; -- 定义变量
Declare @PM varchar(10);
Declare @Part varchar(20);
Declare @Arch int;
Declare @Heap_Num varchar(20);
Select @ID=PPQ_Limit_ID From inserted -- 变量赋值 PPQ_Limit_ID为触发表的字段名
Select @PM=PM_Code From inserted
Select @Part=Part_Num From inserted
Select @Arch=Archive_Times From inserted
Select @Heap_Num=Heap_Num From inserted
if (@PM='DES.F')
begin
insert into 表名2 (Host_Name,User_Name,Date_Time,Commit_Type,Commit_SQL,Editor_Remark,
Key_Word,Module_Path) values
('George','test',getdate(),'insert',@ID,@Arch,@Part+';'+@Heap_Num,'DES.SCANNER')
end
END
go
删除触发器
if exists(select * from sys.triggers where name = 'TRT_Insert')
drop trigger TRT_Insert;
go