货保金更改后解决方案【待完善】

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO 
CREATE TRIGGER TRG_JXDDMX_UPDATE 
   ON  [JXDDMX]
   AFTER UPDATE 
AS 
BEGIN 
	IF UPDATE(isxyhbj)
	BEGIN 
		UPDATE a
			SET a.isxyhbj = b.isxyhbj
		FROM jh_rkmx AS a
		     INNER JOIN Inserted AS b ON a.xgdjbh = b.djbh AND a.spid = b.spid 
		     
		UPDATE a
			SET a.isxyhbj = b.isxyhbj
		FROM TW_CGDD_PICI AS a
		     INNER JOIN Inserted AS b ON a.xgdjbh = b.djbh AND a.spid = b.spid 
		
		UPDATE a
			SET a.isxyhbj = c.isxyhbj
		FROM pf_ckmx AS a
		     INNER JOIN TW_CGDD_PICI AS b ON a.spid = b.spid AND a.pihao = b.pihao AND a.pici = b.pici
		     INNER JOIN Inserted AS c ON b.xgdjbh = c.djbh AND b.spid = c.spid 
		
		UPDATE a
			SET a.isxyhbj = c.isxyhbj
		FROM pf_ckmx_hbjfh AS a
		     INNER JOIN TW_CGDD_PICI AS b ON a.spid = b.spid AND a.pihao = b.pihao AND a.pici = b.pici
		     INNER JOIN Inserted AS c ON b.xgdjbh = c.djbh AND b.spid = c.spid      
	END
END
GO

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值