Delete Duplicate records from the table database

select distinct * into #Temp from Tablename

truncate table Tablename

insert Tablename(bookid,authorid,auname)
select bookid,authorid,auname
from #Temp

drop table #Temp


Author: Sumit26 Dec 2008 Member Level: Silver   Points : 1

Nice One.....
Keep It Up .......
Post Other Also Like This
Good Work


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: