[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