I have a situation to find the duplicate rows in a table.There are several methods to do this, I think one of the best method is using checksum.I had created a table called Test with columns (ID,name and row unique ) and I inserted the values
Then I updated the table test column row unique with check sum(id,name).
Look here the last rowunique value is changed ,sice it contains ID 2.Hope everyone like this article,I like to know your comments about this.