sql server – what is binary_checksum in SQL? and how does it work?

sql server – what is binary_checksum in SQL? and how does it work?

BINARY_CHECKSUM usually used to detect changes in a row. If any row has any value changed, this function can be used to figure out if the values are changed in the rows.
However, if the row is changed from A to B and once again changed back to A, the BINARY_CHECKSUM cannot be used to detect the changes.

Hope you already check this.
binary_checksum

binary_checksum-and-working-example

Alternative to Binary_CheckSum :Using HASHBYTES() to compare columns

checksum-functions-in-sql-

sql server – what is binary_checksum in SQL? and how does it work?

Leave a Reply

Your email address will not be published.