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_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 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_ID,Emp_Name,Emp_Sal,Audit_Action,Audit_Timestamp) values (@empid,@empname,@empsal,@audit_action,getdate()); PRINT ' AFTER DELETE TRIGGER fired.' GO

Deleted And Inserted Table Into Trigger in SQL Server

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)