Paul White (8/10/2009)
RBarryYoung (8/10/2009)
To clarify: HashBytes w/ SHA1 is nigh-unbreakable.Hey Barry,
On the other hand, it is relatively slow, only works on strings, and returns varbinary(8000).
If the task is to detect changes in a row of data, would you use HashBytes (SHA1) alone?
Paul
In Lowell's example, it also turned a 13 byte string into a 20 byte Varbinary so it's expensive, too.
But, I believe that Barry's point was simply that it is unbreakable... not like CHECKSUM at all. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.