SQL - Trouver des lignes dupliquées
27 Oct
Posted by Martin Filliau as Code, Essentiel, Technologies
Tags: sql
SELECT Column1, Column2, COUNT (*) AS NumberOfEntries
FROM Table
GROUP BY Column1, Column2
HAVING COUNT(*) > 1
EXEC sp_rename
@objname = ‘table_name.old_column_name’,
@newname = ‘new_column_name’,
@objtype = ‘COLUMN’
