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 ?