software-mariodiana
11/17/2014 - 7:52 PM

Create a hash code for every row in a table.

Create a hash code for every row in a table.

SQL_hashcode.sql
content_copyfile_download
UPDATE MyTable
SET HashcodeField = SHA1(
    CONCAT(
        SignificantField1, 
        SignificantField2, 
        SignificantField3, 
        SignificantFieldEtc
    )
);