0 Insert After Trigger in Sql Server 2005

Friends Here i am going to Create insert after Trigger in Sql Server 2005

Step 1:-  Create a new table "emp1"



CREATE TABLE [dbo].[ emp1 ](
[Emp_ID] [int] IDENTITY(1,1) NOT NULL,
[Emp_name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Emp_Sal] [decimal](10, 2) NULL
) ON [PRIMARY]


Step 1:-  Create a Another New table "emp2"



CREATE TABLE [dbo].[emp2](
[Emp_ID] [int] NULL,
[Emp_name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Emp_Sal] [decimal](10, 2) NULL,
[Audit_Action] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Audit_Timestamp] [datetime] NULL
) ON [PRIMARY]


Step 3:- Creating Insert After Trigger



ALTER TRIGGER [dbo].[trgafterinsertinsql] ON [dbo].[emp1]
FOR INSERT
AS
declare @empid int;
declare @empname varchar(100);
declare @empsal decimal(10,2);
declare @audit_action varchar(100);

select @empid=i.Emp_ID from inserted i;
select @empname=i.Emp_Name from inserted i;
select @empsal=i.Emp_Sal from inserted i;
set @audit_action='Inserted Record -- After Insert Trigger.';

insert into emp2

           (Emp_ID,Emp_Name,Emp_Sal,Audit_Action,Audit_Timestamp)
values(@empid,@empname,@empsal,@audit_action,getdate());

PRINT 'AFTER INSERT trigger fired.'