34,576
社区成员
发帖
与我相关
我的任务
分享
USE [CQMKYYSFWL]
GO
/****** Object: Trigger [dbo].[clients_INSERT] Script Date: 2018-06-14 10:05:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[clients_INSERT]
ON [dbo].[clients]
AFTER INSERT
AS
INSERT INTO T04_INF_JC_DWZL
(
DANW_NO,DANW_NAME,BEACTIVE,GENGX_TIME,LIANX_STAFF,DIZ_PHONE,ZT
)
SELECT
'CQMK'+SUBSTRING(CAST(10000000+client_id AS VARCHAR(10)),2,8),Name,'Y',CONVERT(VARCHAR(19),GETDATE(),120),contact_personal,Address+phone_number,'Y'
FROM
INSERTed
USE [CQMKYYSFWL]
GO
/****** Object: Trigger [dbo].[clients_UPDATE] Script Date: 2018-06-14 10:08:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[clients_UPDATE]
ON [dbo].[clients]
AFTER UPDATE
AS
UPDATE a SET
a.DANW_NAME=b.Name,a.LIANX_STAFF=b.contact_personal,a.DIZ_PHONE=b.Address+b.phone_number,a.zt='Y',a.GENGX_TIME=CONVERT(VARCHAR(19),GETDATE(),120) FROM T04_INF_JC_DWZL a,INSERTed b WHERE a.DANW_NO ='CQMK'+SUBSTRING(CAST(10000000+b.client_id AS VARCHAR(10)),2,8)