Hi Guys I have Employee Table have 10 employee i need any edit in any employee in Employee table
registering in database in another table EmployeeHistory table
Example
EmployeeID 10
EmployeeName adil
Nationality german
Job Engineer
suppose i changed Naionality from german to italian
registering this changed in another table EmployeeHistory table
How to register only changing in record in another table
what codition i write to take only difference in another table
I need to do that to know what changes ahppen in database every day
please help me
Manish Kumar ChoudharyPosted Nov 24, 2014, 10:56 PM
you can create trigger for this,Read following link
http://www.c-sharpcorner.com/UploadFile/ee01e6/track-user-activity-while-performing-crud-operation-in-datab/