3 ms·
checksum and checksum_agg do not work for all data items, at least for SQL server "Noncomparable data types" for checksum and "null" for checksum_agg are show s
by amtamt 3y ago
checksum and checksum_agg do not work for all data items, at least for SQL server "Noncomparable data types" for checksum and "null" for checksum_agg are show stopper.
Also, checksum/ checksum_agg do not seem like SQL standard functions.
referring https://www.postgresql.org/docs/current/features.html https://www.postgresql.org/docs/current/features.html and https://en.wikipedia.org/wiki/SQL:2023#New_features https://en.wikipedia.org/wiki/SQL:2023#New_features.
- LeonB 3y agoI remember casting some types to varbinary and then using fn_repl_hash_binary() to generate the hashes. And by “remember” I mean I wrote it down here so that I wouldn’t have to - https://til.secretgeek.net/sql_server/bulk_comparison_with_hashbytes.html#solution-for-versions-less-than-sql-server-2016 https://til.secretgeek.net/sql_server/bulk_comparison_with_h...