Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
To create History table to record changes in fields
Message
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
To create History table to record changes in fields
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01135878
Message ID:
01135878
Vues:
84
I want to create a history table for an existing table. This existing table has more then 250 fields. I want to enter a new row in the history table giving info like..which field is changed, old_value, new_value and date when changed.One of the way is to use trigger but how to find out which field changed. I want to use only SQL server and no programming language....Any information is highly appreciated.

Thanks
Bharat
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform