Table and Column Checksums

Following my last posts on Change Data Capture and Change Tracking, here is another tip regarding tracking changes: table and colum checksums.

The concept is: each time a column value changes, the checksum also changes. You can use this simple method to see if a table has changed very easily, however, beware, different column values may generate the same checksum. Here's the SQL:


-- table checksum
SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) FROM TableName

-- column checksum
SELECT CHECKSUM_AGG(BINARY_CHECKSUM(ColumnName)) FROM TableName

-- integer column checksum
SELECT CHECKSUM_AGG(IntegerColumnName) FROM TableName

Here are the reference links on the CHECKSUM, CHECKSUM_AGG and BINARY_CHECKSUM functions:

Bookmark and Share

                             

No Comments