Cyclone (4/27/2011)
Hi,We use SHA1 and store the result as Varbinary(MAX).
Do you see any problems with this ?
Thanks
Yes, there is a problem: a varbinary(max) column can't be a key column in an index, so if you want to use your hash in an index you shouldn't use varbinary(max). That's the only problem I can think of.
Tom