lundi 1 décembre 2014

Report individual changes to data


I need to produce a daily extract on the individual changes to a dataset. So, there are 14 tables containing product and customer information and the extract must only show records from each table that are newly entered or records that have had any column updated.


What would be the best way to do this please?


We are using SQL Server 2008 R2, and develop in C#.


Thanks





Aucun commentaire:

Enregistrer un commentaire