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

Can you give me a example for my table

according to my table columns, Actually i am confused by using triggers.

0

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.

0

Ramchand Repalle11y ago

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

0