[dba-SQLServer] [AccessD] Hash value of record fields

Gustav Brock gustav at cactus.dk
Mon Jan 20 08:44:15 CST 2014


Hi all

As the tables live in SQL Server, I found out that T-SQL contains a function
CheckSum for exactly this.
So I could just run a pass-through query to get the checksum/hash value. 

Or do I miss something?

/gustav


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
Sendt: 20. januar 2014 14:48
Til: 'Access Developers discussion and problem solving'
Emne: [AccessD] Hash value of record fields

Hi all

I remember that JC worked with hash values for full records to identify
dupes.

I'm looking for a fast native VBA function to return a hash value for a
variable count of fields (using ParamArray).
It doesn't have to be fancy MD5 or the like, just fast.

Before I start binging/googling, I wonder if anyone have a proven function
at hand?

/gustav 




More information about the dba-SQLServer mailing list