Udostępnij za pośrednictwem

How to remove duplicate rows from a table in SQL Server

  • Artykuł

Microsoft SQL Server tables should never contain duplicate rows, nor non-unique primary keys. For brevity, we will sometimes refer to primary keys as "key" or "PK" in this article, but this will always denote "primary key." Duplicate PKs are a violation of entity integrity, and should be disallowed in a relational system. SQL Server has various mechanisms for enforcing entity integrity, including indexes, UNIQUE constraints, PRIMARY KEY constraints, and triggers.

The following is here : https://support.microsoft.com/default.aspx/kb/139444 

image