delete duplicate rows from tabledata

[Anon]

hello friends

please help me in deleting the duplicate rows from the table in MSSql server7.0 database.

bye

[tomhath]

First, backup your database.

Try this out on a copy of the real table first, so you don't accidentally destroy everything.

Now, make another table just like the one with duplicates (same columns), but empty.

Run this:

insert into table2
select distinct * from table1

Now you can rename table2, or delete all rows from table1 and insert from table2.