CHECKSUM is a integer-value computing function against its parameter. The result value is unique for incoming parameters. The following query shows how the CHECKSUM function reflects a parameter's value:
SELECT CHECKSUM('hello') -- 533340124 , CHECKSUM('Hello') -- 533340124 , CHECKSUM('olleh') -- 1600790340 , CHECKSUM('hloel') -- 1606885152
This simple query shows that even if letters in a parameter of the function are the same, every change is reflected in the value produced by the function. Values are written as comments. We can also use the CHECKSUM function for computing the CHECKSUM value for one or more columns in a table. The following code demonstrates how to use more columns as parameters for a CHECKSUM function:
SELECT ...
