SQL Server 触发器编写

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