tag:blogger.com,1999:blog-495177919198719500.post5928970654423405123..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Generate a HASH value using SQL Server 2005/2008Suprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-495177919198719500.post-91919993103916825112011-11-09T14:38:50.805-08:002011-11-09T14:38:50.805-08:00sorry that was my fault, i did something like HASH...sorry that was my fault, i did something like HASHBYTES('SHA1', cast( '...really large string' as nvarchar)) which when you don't specify a size it uses 30 so it was truncating its value, my badjbtatrohttps://www.blogger.com/profile/09649328533541422491noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-86927966087795821472011-11-09T07:46:10.336-08:002011-11-09T07:46:10.336-08:00the function only uses the first 30 characters of ...the function only uses the first 30 characters of your stringjbtatrohttps://www.blogger.com/profile/09649328533541422491noreply@blogger.com