Frédéric Brouard Commented 1 Years ago through
Blogs | 1 Point
Don't forget that CHECKSUM can cause collisions.
To solve this, use both predicate.
SELECT #checksumsTableId
FROM #checksumsTable
WHERE CHECKSUM('AAFPPFFUFPFPUFPAFAUPFKKAFAKUFAAUK(...cut!)') = checkSumValue
AND 'AAFPPFFUFP...