////////
INSERT
////////
USE [WEIGHDB]
GO
/****** Object: Trigger [dbo].[TB_CUSTO_INSERT] Script Date: 2017-12-18 오후 5:33:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date:
-- Description:
-- =============================================
ALTER TRIGGER [dbo].[TB_CUSTO_INSERT]
ON [dbo].[TB_CUSTO]
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT * FROM inserted
-- Insert statements for trigger here
IF @@RowCount > 0
BEGIN
INSERT INTO TB_CUSTO_IF
SELECT CUSTONO, CUSTONM, Rem1, 'N', 'I', getdate() FROM inserted
END
END
//////////
UPDATE
//////////
USE [WEIGHDB]
GO
/****** Object: Trigger [dbo].[TB_CUSTO_UPDATE] Script Date: 2017-12-18 오후 5:34:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Name
-- Create date:
-- Description:
-- =============================================
ALTER TRIGGER [dbo].[TB_CUSTO_UPDATE]
ON [dbo].[TB_CUSTO]
AFTER UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT * FROM inserted
-- Insert statements for trigger here
IF @@RowCount > 0
BEGIN
INSERT INTO TB_CUSTO_IF
SELECT CUSTONO, CUSTONM, Rem1, 'N', 'U', getdate() FROM inserted
END
END
////////
DELETE
////////
USE [WEIGHDB]
GO
/****** Object: Trigger [dbo].[TB_CUSTO_DELETE] Script Date: 2017-12-18 오후 5:34:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Name
-- Create date:
-- Description:
-- =============================================
ALTER TRIGGER [dbo].[TB_CUSTO_DELETE]
ON [dbo].[TB_CUSTO]
AFTER DELETE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for trigger here
SELECT * FROM deleted
-- Insert statements for trigger here
IF @@RowCount > 0
BEGIN
INSERT INTO TB_CUSTO_IF
SELECT CUSTONO, CUSTONM, Rem1, 'N', 'D', getdate() FROM deleted
END
END