Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Rixon,
The standard way of doing this in SQL 2000 is to either use the UPDATE() function or COLUMNS_UPDATED() function. The first uses the column name and the second uses a bitmask. COLUMNS_UPDATED() is more flexible if you have multiple columns to check. UPDATE() is fine if only one column to check.
HTH.
- Val Matison
>Is there a way to determine if a table record has changed if that table does not have a datetime stamp? Right now I'm comparing the current table with a previous copy of the table to see if any data has changed.
>
>Can triggers do this instead? In other words, if a field is changed, can it trigger an update to a remote table that needs to be kept in sync? If so, what would that trigger look like?
>
>Thanks in advance.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement