Explain about BINARY CHECKSUM..

 Posted by Bharathi Cherukuri on 7/24/2012 | Category: Sql Server Interview questions | Views: 1280 | Points: 40
Answer:

If any modifications are done to the row of the table, this BINARY CHECKSUM function identifies them which takes case-sensitivity into account.

Example:


SELECT ProductID, BINARY_CHECKSUM(*) AS 'Binary Checksum'
FROM Products


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response