[thelist] SQL: finding "new" records in a table

MILLER David R. dmiller at mcc.ca
Tue Sep 4 12:39:49 CDT 2007


Just thinking out loud...

Could you compute a hash of each row, store it, then use it to compare
the data? SQL Server 2005 has a HashBytes function; I'm sure other DBMSs
have something similar.

>There isn't anything like an Is_changed flag on the appointments table 
>and I don't have the option of modifying the table structure or the 
>process that adds/updates appointments.
>
>Any thoughts on the most efficient and logical way to only dump new or 
>changed appointments?

-----------------------------------------
David R. Miller
Senior Software Developer
Medical Council of Canada
-----------------------------------------



More information about the thelist mailing list