create trigger [Tri_PHAppData] on [dbo].[PHJRD] after update as declare @NewValueJZ int declare @ErrorCnt int begin select @NewValueJZ = JZ from inserted if @NewValueJZ = 1 begin set @ErrorCnt = 0 Begin transaction --OpenDataSource('sqloledb','data source=192.168.1.200;user id=sa;password=123').vskonne.dbo.PeiHuoAppList insert into HW_09030301.dbo.PeiHuoAppList(djbh,djrq,djgl,jgxz,yjwg,qddm, dm1,dm1kw,dm2,dm2kw,dm3,dm3kw,dm4,dm4kw,dm5,dm5kw, manager,sl,sl1,sl2,sl3,je,je1,je2,je3,bzje, remark,orderid,zdr,zdrq,noticetime) select djbh,rq,ydjh,djxz,days,qddm, dm1,dm1_1,dm2,dm2_1,dm3,dm3_1,dm4,dm4_1,dm5,dm5_1, ygdm,sl,sl_1,sl_2,sl_3,je,je_1,je_2,je_3,bzje, bz,lxdj,zdr,rq_4,yxrq from inserted set @ErrorCnt = @ErrorCnt + @@error --OpenDataSource('sqloledb','data source=192.168.1.200;user id=sa;password=123').vskonne.dbo.PeiHuoAppListMX set identity_insert HW_09030301.dbo.PeiHuoAppListMX on insert into HW_09030301.dbo.PeiHuoAppListMX(djbh,mxbh,spxh, productid,spproperty1,spproperty2, sl,sl1,sl2,sl3,dj,zk, remark,je,bzje,bzj) select A.djbh,A.mxbh,A.mibh, A.spdm,A.gg1dm,A.gg2dm, A.sl,A.sl_1,A.sl_2,A.sl_3,A.dj,A.zk, A.bz,A.je,A.bzje,A.ckj from PHJRDMX A inner join inserted B on A.DJBH = B.DJBH set @ErrorCnt = @ErrorCnt + @@error set identity_insert HW_09030301.dbo.PeiHuoAppListMX off if @ErrorCnt = 0 Commit transaction else Rollback transaction end end