How to Track Number of Changes Occured in a Column? T-SQL - SQL Server
- by user327387
For example, i have a column named EmployeeName.
Every time a user changes/fix his name, i need to keep a count. If he changes his name twice, then count is 2. Also, i need to store the time of every change employee makes on EmployeeName e.g. if the name essentially is James and time created is 9:00 AM and then employee changes to John on 11:00…