Search 
Friday, July 30, 2010 ..:: Examples » Handling Duplicate Records ::.. Register  Login
 Handling Duplicate Records
Identifying Duplicate Records - Sunday, December 02, 2007
This script identifies records where every column is an exact duplicate of another record in the table.
 read more ...

Identifying Non-unique Columns - Sunday, December 02, 2007
This script identifies the values of a column where their values are not unique within the table.
 read more ...

Updates All But First Duplicate - Sunday, December 02, 2007
This script processes through a table that contains duplicate column values, and for each duplicate column value it updates all but one of them.
 read more ...

Updates All but the First One Another Way - Sunday, December 02, 2007
This script processes through a table that contains duplicate column values, and for each duplicate column value it updates all but one of them.
 read more ...


  
SQL Tools Heaven
Exceptional DBA
SQL Backup
Copyright 2007, 2008 by SQLServerExamples.com   Terms Of Use  Privacy Statement