删除表数据触发器记录删除的数据

create trigger trigger_SDPHD
on SDPHD
after delete
as
declare @DJBH varchar(20)

--从删除表里面获取出来这个删除的数据
select @DJBH=DJBH from deleted
begin
    --delete SDPHD_DELETE where DJBH=@DJBH
    insert into SDPHD_DELETE(DJBH,RQ,YDJH,DJXZ,FPLX,LXDJ,DAYS,DM1,DM1_1,DM2,DM2_1,DM4,DM4_1,QDDM,QYDM,YGDM,SL,SL_1,SL_2,SL_3,
    BZSL,JE,JE_1,JE_2,JE_3,BZJE,CJ,TJ,XC,XCRQ,YS,YSRQ,JZ,JZRQ,JS,JSRQ,SH,SHRQ,SP,SPRQ,LL,LLRQ,ZDR,YSR,
    JZR,JSR,SHR,SPR,LLR,YXRQ,RQ_4,BZ,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5,BYZD6,BYZD8,BYZD9,BYZD10,BYZD11,BYZD12,BYZD13,ZS,ZSR,ZSRQ,DM5,
    DM5_1,ZDHHZQ,WHHK,ZDHHK,HBHL,FZXX,FP,ZRJE,ZRHJE,CY,CYDH)
    select DJBH,RQ,YDJH,DJXZ,FPLX,LXDJ,DAYS,DM1,DM1_1,DM2,DM2_1,DM4,DM4_1,QDDM,QYDM,YGDM,SL,SL_1,SL_2,SL_3,
    BZSL,JE,JE_1,JE_2,JE_3,BZJE,CJ,TJ,XC,XCRQ,YS,YSRQ,JZ,JZRQ,JS,JSRQ,SH,SHRQ,SP,SPRQ,LL,LLRQ,ZDR,YSR,
    JZR,JSR,SHR,SPR,LLR,YXRQ,RQ_4,BZ,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5,BYZD6,BYZD8,BYZD9,BYZD10,BYZD11,BYZD12,BYZD13,ZS,ZSR,ZSRQ,DM5,
    DM5_1,ZDHHZQ,WHHK,ZDHHK,HBHL,FZXX,FP,ZRJE,ZRHJE,CY,CYDH from deleted where DJBH=@DJBH
end