Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from table in sql server
- 12 Answers
- 23198 Views
- HCL, UHG, I also Faced
- E-Mail Answers
Answer Posted / vineet dhamija
the best approach i came across in simple form too
just create a temporary table with the distinct values and
truncate this table than copy the values back and u r good to go
select distinct * into #temp from urtable
truncate table urtable
insert into urtable select * from #temp
drop table #temp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a raid and what are different types of raid configurations?
Show Practically Sql Server Views are updatable?
What is the return type of executeupdate ()?
Who developed sql server?
What is difference between index and primary key?
Do you know how to make remote connection in database?
What is a cursor, index in sql?
What do you understand by triggers?
How can you insert null values in a column while inserting the data?
How raid can influence database performance?
What is cube dimension? : sql server analysis services, ssas
What is rs.exe utility?
What does dml stand for?
Where actually sql azure database is hosted?
How to truncate the log in sql server 2012? : sql server database administration
