Scribd
Upload
60 views

Trigger

Uploaded by

niit cts
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
60 views

Trigger

Uploaded by

niit cts
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

CREATE TABLE EMPLOYEE

(EMP_ID INT IDENTITY,


EMP_NAME VARCHAR(20),
SALARY DECIMAL(10,2)
)

CREATE TABLE EMPLOYEE_AUDIT


(EMP_ID INT IDENTITY,
EMP_NAME VARCHAR(20),
SALARY DECIMAL(10,2),
AUDIT_ACTION VARCHAR(30)
)

CREATE TRIGGER TRIGERAFTERINSERT ON EMPLOYEE


FOR INSERT/AFTER INSERT
AS
DECLARE @EMPID INT;
DECLARE @EMPNAME VARCHAR(20),
DECLARE @SALARY DECIMAL(10,2)
DECLARE @AUDITACTION VARCHAR(20)

SELECT @EMPID=i.EMPID FROM INSERTED i


SELECT @EMPNAME=i.EMPNAME FROM INSERTED i
SELECT @SALARY=i.SALARY FROM INSERTED i

SET @AUDITACTION='INSERTED'

INSERT INTO EMPLOYEE_AUDIT VALUES(@EMPID,@EMPNAME,@SALARY,@AUDITACTION)

You might also like