select distinct eno,ename into temp_table from main

how to delete duplicate rows in sql server2005

Question Posted / apps

Answer Posted / apps

select distinct eno,ename into temp_table from main_table
drop table main_table
-----
sp_rename temp_table,main_table

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to get a list of all tables with "sys.tables" view in ms sql server?

1081

What is the primary use of the model database?

1128

Explain various On-Delete options in a DB table. Which is the default option?

1531

How to choose all records from the table?

1102

What is checkpoint in sql server?

1214

How do I clean up sql server transaction log?

1123

How will you make an attribute not process? : sql server analysis services, ssas

1157

How to create a testing table with test data in ms sql server?

1140

explain databases and sql server databases architecture? : Sql server database administration

1012

Difference between drill down and drill through report.

1003

What are the types of indexes?

1131

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1038

Explain what is “asynchronous” communication in sql server service broker?

956

What do you understand by a view? What does the with check option clause for a view do?

1055

What are the two modes of authentication in sql server?

1134