Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
SQL Trigger for adding Old Val and New Val to audit table
Deepak Ratan
Jun 22 2015 5:28 AM
479
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
How to Create a Audit table
Query