ALTER TRIGGER [UPDATE_XGSJ]
ON [dbo].[BZRYXXB]
AFTER UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for trigger here
---XM
if update(XM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--XMPY
if update(XMPY)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
---XNBH
if update(XNBH)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--CYM
if update(CYM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--XBM
if update(XBM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--CSRQ
if update(CSRQ)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--CSD
if update(CSD)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--JG
if update(JG)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--MZ
if update(MZ)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--GJDQ
if update(GJDQM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
---SFZJLX
if update(SFZJLXM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--SFZJH
if update(SFZJH)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--HYZT
if update(HYZTM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--GATQW
if update(GATQWM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
---ZZMM
if update(ZZMM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--XYZJ
if update(XYZJM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--XX
if update(XXM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--ZP
if update(ZP)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--SFZJYXQ
if update(SFZJYXQ)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--RYPM
if update(RYPM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--LSDWM
if update(LSDWM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--LSDWM1
if update(LSDWM1)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--LSDWM2
if update(LSDWM2)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--LXDH
if update(LXDH)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--DZXX
if update(DZXX)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--XGSJ
if update(XGSJ)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--SJYBM
if update(SJYBM)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
--RYYXBS
if update(RYYXBS)
begin
update [dbo].[BZRYXXB]
set [XGSJ]=getdate()
from BZRYXXB,inserted
where BZRYXXB.XNBH=inserted.XNBH
end
END
