Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to retrieve info on latest write to a table?
Message
From
08/10/2002 13:34:28
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00707680
Message ID:
00708859
Views:
12
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform