SQL Server using Hashbytes for non sensitive data

99 Views Asked by At

I am wondering why there would be a reason to use the hashbytes algorithm when the data below does not contain any passwords or other sensitive data like this. Is there really a need to use this if you are not dealing with passwords, credit card numbers etc?

   select  distinct
    @reportIdLeiDuplicates,
    wp.CrmPartyId,
    wp.GtId,  
    convert(varchar(20), 
            hashbytes('SHA1', isnull(wp.CrmPartyId, '') + isnull(wp.GtId, '') ),    
            2),  
0

There are 0 best solutions below