Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to retrieve info on latest write to a table?
Message
De
08/10/2002 13:34:28
 
 
À
07/10/2002 11:26:20
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00707680
Message ID:
00708859
Vues:
13
>The only automatic to detect that a row was changed is with a timestamp. Sadly, the timestamp has nothing to do with dates and times. It's just a rolling number.
>

Hmmm... so, what if you inserted a record into the table and read the timestamp save it. Two days later, come back and update that record, read the timestamp... Then, all the records where timestamp between timestamp1 and timestamp2 would be the records that were already updated???

Isn't it just a binary number?

BOb
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform