Deleted And Inserted Table Into Trigger in SQL Server

Please chk if u not get solution from this trigger then reply me...


//Insert trigger
CREATE TRIGGER trgAfterInsert ON [dbo].[Employee_Test]  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 Employee_Test_Audit            (Emp_ID,Emp_Name,Emp_Sal,Audit_Action,Audit_Timestamp)  values(@empid,@empname,@empsal,@audit_action,getdate());  PRINT 'AFTER INSERT trigger fired.' Go

//Deleting Trigger
 
CREATE TRIGGER trgAfterDelete ON [dbo].[Employee_Test]  AFTER DELETE AS declare @empid int; declare @empname varchar(100); declare @empsal decimal(10,2); declare @audit_action varchar(100);  select @empid=d.Emp_ID from deleted d; select @empname=d.Emp_Name from deleted d; select @empsal=d.Emp_Sal from deleted d; set @audit_action='Deleted -- After Delete Trigger.';  insert into Employee_Test_Audit (Emp_ID,Emp_Name,Emp_Sal,Audit_Action,Audit_Timestamp)  values(@empid,@empname,@empsal,@audit_action,getdate());  PRINT 'AFTER DELETE TRIGGER fired.' GO