Delete Duplicate records from the table database

Posted Date: 23 Dec 2008	Resource Type: Code Snippets	Category: SQL
Author: Prashant Mishra	Member Level: Bronze
Rating:	Points: 2

select distinct * into #Temp from Tablename

truncate table Tablename

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

drop table #Temp

Responses

Author: Sumit 26 Dec 2008

Member Level: Silver Points : 1

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

Regards
Sumit
sumi2987@gmail.com

Feedbacks

Popular Tags

What are tags ?

Search Tags

Delete Duplicate records from the table database .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: A query which returns DDMMYYYY from MMDDYYYY Date format
	Previous Resource: Importing data from excel to sql server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

More Resources