DB트리거 사용

트리거 이름을 저장할 테이블을 생성

USE [HM_160610]
GO

/****** Object:  Table [dbo].[IQa206A]    Script Date: 06/10/2016 10:26:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[LOG_A_TRIGGER](
    [TRIGGERNAME] [char](50) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

저장할 로그테이블 생성

USE [HM_160610]
GO

/****** Object:  Table [dbo].[IQa206A]    Script Date: 06/10/2016 10:26:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[LOG_MID208](
    [createdate] datetime,
    [StatusCode] [char](5) null,
    [ID] [int] NULL,
    [LogInfo] [char] (50) NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

트리거 생성 만들어진 트리거이름을 위에서 만든 트리거이름테이블에 추가해서사용

수정시

CREATE TRIGGER Mid208_CHAtrg ON iqa208a
FOR UPDATE
AS
    insert into [log_mid]
    select GETDATE() ,'Befor',  * from deleted
    insert into [log_mid]
    select GETDATE() ,'After',  * from inserted
GO

삭제시
create trigger Mid208_DELtrg on iqa208a
FOR DELETE
AS
    insert into [log_mid]
    select GETDATE(), 'Delet', * from deleted
GO