Wednesday, July 30, 2008

Removing Duplicate Records using SQL Server 2005 | Servers and Storage | TechRepublic.com

 

Duplicate Records

Duplicate records can occur numerous ways, such as loading source files too many times, keying the same data more than once, or from just bad database coding. Having a primary key on your table (and you always should have one) can will in the removal of the duplicate records, but even w/ a primary key it is never a fun task to have handed to you to complete.

Removing Duplicate Records using SQL Server 2005 | Servers and Storage | TechRepublic.com

1 comment:

webtips said...

The below article showed me a simple way
Delete Duplicate Rows in Sql Server

-Webtips