Deleted And Inserted Table Into Trigger in SQL Server

Question

I want to know what is deleted and inserted table into trigger in SQL Server. Thank you

Santhosh Kumar Jayaraman · Answer

http://www.codemile.com/sql-server/2011/02/14/magic-tables-in-sqlserver-inserted-table-and-deleted-table/

Naeem Khan · Answer

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_IDEmp_NameEmp_SalAudit_ActionAudit_Timestamp) values (@empid@empname@empsal@audit_actiongetdate()); PRINT ' AFTER INSERT trigger fired.' Go //Deleting Trigger CREATE TRIGGER trgAfter Delete 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 delete d d; select @empname=d.Emp_Name from delete d d; select @empsal=d.Emp_Sal from delete d d; set @audit_action= ' Delete d -- After Delete Trigger .' ; insert into Employee_Test_Audit (Emp_IDEmp_NameEmp_SalAudit_ActionAudit_Timestamp) values (@empid@empname@empsal@audit_actiongetdate()); PRINT ' AFTER DELETE TRIGGER fired.' GO