我是个新手大家,会的朋友来帮帮我。
现在需要改,如果表nyxscpdl中字段(tjdh)与 A2008XSYJ(tjdh)相同 则更新,否则就插入表A2008XSYJ
麻烦帮忙看看怎么改一下。谢谢了
CREATE trigger reloadTT on xsyjupdate for update
as
begin
if update (mo)
begin
declare @m int
set @m=0
select @m=cast(mo as int) from inserted
if @m=1
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl01,je01,lr01,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=2
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl02,je02,lr02,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=3
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl03,je03,lr03,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=4
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl04,je04,lr04,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=5
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl05,je05,lr05,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=6
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl06,je06,lr06,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=7
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl07,je07,lr07,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=8
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl08,je08,lr08,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=9
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl09,je09,lr09,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=10
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl10,je10,lr10,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=11
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl11,je11,lr11,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
if @m=12
insert into A2008XSYJ (tjdh,ryxm,cpmc,xl12,je12,lr12,ddkpzl,ddthzl,kpwtzl,jrkp) select tjdh,ryxm,cpmc,xszl,zxse,xslr,ddkpzl,ddthzl,kpwtzl,jrkp from nyxscpdl
end
end