1,075
社区成员
发帖
与我相关
我的任务
分享
--dw的更新时语句为
UPDATE zybrzl SET sflx = 1, nl = '25', rybq = '1', rq = '2014-06-12 10:36:27.703', cyks = '11' WHERE zyid = 5569
--触发器代码
ALTER TRIGGER [dbo].[Tri_zybrzl_update_lis]
ON [dbo].[zybrzl]
for UPDATE
AS
IF UPDATE(xm) OR UPDATE(xb) OR UPDATE(nl) OR UPDATE(nldw)
BEGIN
return
UPDATE t1
SET V_BRXM=i.XM,v_xb= (case rtrim(ltrim(i.xb)) when '1' then '男' when '2' then '女' else null end),v_nl=i.nl,V_NLLX=i.nldw
FROM
V_LIS_ZYSFXX v ,his_lis.dbo.tb_brsfxxb t1,INSERTED i
WHERE v.V_Lsh=t1.V_LSH
AND t1.D_SFSJ>DATEADD(dd,-7,GETDATE())
AND i.blh=v.V_LSH
AND t1.I_BRLBDM=1
UPDATE t1
SET V_BRXM=i.XM,v_xb= (case rtrim(ltrim(i.xb)) when '1' then '男' when '2' then '女' else null end),v_nl=i.nl,V_NLLX=i.nldw
FROM
V_LIS_ZYSFXX v ,his_lis.dbo.TB_BRSFXXB_JYSQ t1,INSERTED i
WHERE v.V_Lsh=t1.V_LSH
AND t1.D_SFSJ>DATEADD(dd,-7,GETDATE())
AND i.blh=v.V_LSH
AND t1.I_BRLBDM=1
END