BINARY CHECKSUM

BINARY CHECKSUM

BINARY_CHECKSUM is a function that identifies changes to a row of a table. The results of BINARY_CHECKSUM are impacted by order of columns. BINARY_CHECKSUM takes case-sensitivity into account.

From MSDN (), BINARY_CHECKSUM (*) will return a different value for most, but not all, changes to the row, and can be used to detect most row modifications.

Example of BINARY_CHECKSUM

CREATE TABLE EMP(x INT PRIMARY KEY,
                 Name Varchar(20) )

INSERT INTO EMP VALUES (1, 'AAA')

Select * from EMP

SELECT BINARY_CHECKSUM(*) from EMP

update EMP
set Name='KKK' where x=1

Select * from EMP

SELECT BINARY_CHECKSUM(*) from EMP

update EMP
set Name='AAA' where x=1
SELECT BINARY_CHECKSUM(*) from EMP