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