How can you delete duplicate records in a table with no primary key? Technology Community › Category: T-SQL › How can you delete duplicate records in a table with no primary key? 0 Vote Up Vote Down VietMX Staff asked 4 years ago Use the SET ROWCOUNT command. So if you had 2 duplicate rows you would issue SET ROWCOUNT 1, then your DELETE command then SET ROWCOUNT 0.
VietMX