SQL Trigger for adding Old Val and New Val to audit table

Question

Hi All This is My tables Using trigger in Audit ( SQL ) how can we find OLD Value and NEW value when the table is Insert or Update or Delete Help Tabel : 1 BusinessEntityID int PRIMARY KEY RateChangeDate datetime Rate money PayFrequency tinyint------ > Have to change this column ModifiedDate datetime Tabel : 2 BusinessEntityID int PRIMARY KEY Old_Value tinyint New_Value tinyint ModifiedDate datetime

Deepak Ratan · Answer

Hi Ramchand Repalle  Can you give me a example for my table according to my table columns Actually i am confused by using triggers.

Kannadasan G · Answer

Before doing any update or delete do a select and hold the values in a temp table or variable. Then consider the selected values as old and the incoming input values as new. Hope it will help.

Ramchand Repalle · Answer

Hello Deepak You have to write seperate triggers for insert update delete operations to log the old and new values. Usually The INSERTED table will gives the new or updated value and DEELTED table gives you the deleted record. This link helps you to achieve the required functionality. Please go through this. http://www.aspsnippets.com/Articles/Simple-Insert-Update-and-Delete-Triggers-in-SQL-Server-with-example.aspx Best Regards Ramchand