/****** Object: Trigger [dbo].[trigger_Insert_ProjectItem] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--工程表插入触发器
ALTER trigger [dbo].[trigger_Insert_ProjectItem]
on [dbo].[ProjectItem]
after insert
as
insert into [Log_ProjectItem](GCID, XMID, GCMC, XMMC, JZMJ, GCFL1, GCFL2, GCFL3, SYXZ, SHDXNR, Address, JGLX, JCLX, DSCS,
DXCS, DSMJ, DXMJ, GCZJ, JHKGRQ, JHJGRQ, SGDW, SGDWZZZ, SGDWXMJL, XMJLJBZ, KCDW, KCDWZZZ,
XMKCFZR, XMKCFZRZCZGZH, SJDW, SJDWZZZ, XMJZSJFZR, XMJZSJFZRZCZGZH, XMJGSJFZR,
XMJGSJFZRZCZGZH, JLDW, JLDWZZZSH, JLS, JLSZCJGZH, QualifiedBook, NoticeAndContract, PersonnelList,
OtherFiles, JSDW, JSDWFDDB, JSDWXMFZR, JSDWFZRTEL, BBRQ, JDZSHYJ, XXJD, SHZTID, SHZT, IsTempSave,
ZJY, ZJYMC, SHR, SHRQ, CJRQ, XGRQ, CJR, CGR, BYID
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--工程表插入触发器
ALTER trigger [dbo].[trigger_Insert_ProjectItem]
on [dbo].[ProjectItem]
after insert
as
insert into [Log_ProjectItem](GCID, XMID, GCMC, XMMC, JZMJ, GCFL1, GCFL2, GCFL3, SYXZ, SHDXNR, Address, JGLX, JCLX, DSCS,
DXCS, DSMJ, DXMJ, GCZJ, JHKGRQ, JHJGRQ, SGDW, SGDWZZZ, SGDWXMJL, XMJLJBZ, KCDW, KCDWZZZ,
XMKCFZR, XMKCFZRZCZGZH, SJDW, SJDWZZZ, XMJZSJFZR, XMJZSJFZRZCZGZH, XMJGSJFZR,
XMJGSJFZRZCZGZH, JLDW, JLDWZZZSH, JLS, JLSZCJGZH, QualifiedBook, NoticeAndContract, PersonnelList,
OtherFiles, JSDW, JSDWFDDB, JSDWXMFZR, JSDWFZRTEL, BBRQ, JDZSHYJ, XXJD, SHZTID, SHZT, IsTempSave,
ZJY, ZJYMC, SHR, SHRQ, CJRQ, XGRQ, CJR, CGR, BYID