Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-04 : 14:23:12
niriksha writes "there are a large amount of records in a database
there are many duplicate records in the table
how to remove the duplicate records from the table without making a new table or index?? we can use identity for the problem
the thing to be remembered is that there is very little memory in the disk"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2004-06-04 : 14:23:13
Did you read our article on deleting duplicates? You can easily search for it.
Go to Top of Page
   

- Advertisement -