Hash Code in SQL Server?

Question

I am trying to solve a unique problem. Thanks for any help with this.

Is there an easy way to generate some kind of a hash code for a record based on several of its field values?

I thought about just creating a view with an extra column that concatenates all of the values that I want to check, but I'm checking to see if there is a better way.

I am trying to identify records based on their values, because I need to group parent records by the uniqueness of these child records, if that makes any sense.

Thanks again for any advice.

casperOne · Accepted Answer · 2010-02-18 17:28:55Z

8

SELECT
    HASHBYTES('MD5', CAST(col1 AS VARBINARY(MAX)) + 
        CAST(col2 AS VARBINARY(MAX)))
FROM
    mytable

edited Feb 18, 2010 at 17:28

casperOne

74.7k19 gold badges189 silver badges262 bronze badges

answered Feb 18, 2010 at 17:25

Quassnoi

427k94 gold badges627 silver badges622 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hash Code in SQL Server?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related