Marcin Gol [SQL Server MVP] (9/7/2009) Sergiy (9/7/2009)
Marcin Gol [SQL Server MVP] (9/7/2009)
Sergiy - the paragraph you mentioned change nothing. hash is a hash - and for a given string should always return the same value. did you try to run his query on your sql ?
You probably did not reach the last sentence of the paragraph.
i read it but i feel that we don't understand each other ;-)
my version: for a given string we should always receive same hash, did i say that hash is unique? nope.
maybe other question is right here ... does the implemantion of checksum function has changed over the time ? (sql 2000 -> 2008?); if don't why im getting other values of checksum than Zahran ?
It actually returns the same hash value for unchanged original value.
Is it any different on you machine?
And the topic was actually about uniqueness problem. My reference was about it.