Row comparison in Database

Question

Hai all.....

I have a small doubt..I want to fetch a single row from the database and compare it with all other rows in the database whether they are equal or not.if equal simply i want to delete the row.......

and can i also fetch a complete row as a single object?

if yes how am i go about this.......

Vijaya Kadiyala · Answer

Hi Are you trying to find the duplicate records with in a table or accross the tables??? Thanks -- Vijaya Kadiyala http://dotnetvj.blogspot.com

Mahesh Chand · Answer

Absolutely. What is the criteria of row selection? Any unique ID or keyword or name? You use ExecuteReader method of SqlCommand to fetch records but based on your selection criteria you may get more than one record. Best way to handle this is in your SP at database end. SP should also delete the duplicate row.