Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13424 Views
- Cisco, CTS, HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / pritesh
By using temporary table, But it will delete exactly
duplicate rows NOT RECOMMANDABLE FOR HUGE TABLE. Query will
be.
SELECT DISTINCT * INTO #A FROM TABLE1
TRUNCATE TABLE TABLE1
INSERT INTO TABLE1
SELECT * FROM #A
| Is This Answer Correct ? | 30 Yes | 3 No |
Post New Answer View All Answers
How do we know if any query is retrieving a large amount of data or very little data?
What are the differences between stored procedure and the dynamic sql?
Differentiate sql server reporting services vs. Crystal reports?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Explain different types of index?
Do you know what is xpath?
What is the data type of time?
How to convert character strings into numeric values?
Explain important index characteristics?
how to take backup bcp out for a column in table in sql server?
How does Report Builder support Analysis Services cubes?
Can you explain various data region available in ssrs with their use?
What is the difference between varchar and nvarchar?
Do you know the capabilities of cursors?
How to insert stored procedure result into temporary table?
