SQL Server CheckSum Question
With regards to the above, does anyone know in what circumstances two different values would return the same checksum value?
SQL Server 2000 offers a function called CHECKSUM. The main purpose for this function is to create what are called hash indices. A hash indices is an index built on a column that stores the checksum of the data found in another column in the table. The CHECKSUM function takes data from another column and creates a checksum value. In other words, the CHECKSUM function is used to create a mostly unique value that represents other data in your table. In most cases, the CHECKSUM value will be much smaller than the actual value. For the most part, checksum values are unique, but this is not guaranteed. It is possible that two slightly different values may produce the same identical CHECKSUM value.
I'm looking for something that will generate a unique hash for variations of customer records.
I definitely would not want the same hash to be generated in the following example:
Thanks in advance,
By abcat in forum Database
Last Post: 05-27-2005, 02:01 AM
By David Jones in forum Database
Last Post: 08-31-2001, 12:22 PM
By Levi Nkata in forum Database
Last Post: 04-11-2001, 09:31 AM
By Marie in forum Database
Last Post: 11-20-2000, 05:37 AM
By andriano in forum Enterprise
Last Post: 10-02-2000, 03:54 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL