This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 77%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
i work on sql server 2017 i need to use check sum for hashing but im afraid if i got stuck or issue when compare
my data all will be numbers only or numbers with stick
example of my data
121
121|145
155|233|2231
so are check sum hashing with these number will make issue for me
when comparing for that numbers from database ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)
so are checksum are gurantee
the function CHECKSUM returns an integer value, so max 4 G different values, so as I wrote it's not a unique value, different values can return the same checkum.
See
https://learn.microsoft.com/en-us/sql/t-sql/functions/checksum-transact-sql?view=sql-server-ver15
Here some titbits that I've calculated:
If you take 100000 random 32-bit numbers, the probality for at least one duplicate is 0.3.
If you take a million random 32-bit, the probabilty that all are unique is 1E-50, that is, extremely small.
To add insult to injury, checksum uses a simplistic XOR algorithm, which may increase the likelihood for duplicates.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
"155|233|2231" is not "numbers with sticks", it is a string. SQL Server, and checksum, has no knowledge there are numbers separated by |.
Not clear what your issue is, may can you explain it more detailed, pülease?
A hash value is nothing unique, if it's that what you mean.
suppose i have table have column
idsticks as varchar(200) has value as below
121|233|112
and i need to store id for this text
so i will use checksum
as
checksum('121|233|112')
so are checksum are gurantee
or will have different issue when generating numbers for text
i I only will hashing numbers or numbers with stick
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Hi @ahmed salah
so are checksum are gurantee or will have different issue when generating numbers for text
Please refer to the link offered by Olaf, as you can see from the doc, CHECKSUM () does not guarantee unique results.
Best regards,
LiHong