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

What is collation sensitivity?

1053

Can we call stored procedure in trigger?

941

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1054

What are the dis_advantages of stored procedures, triggers, indexes?

2211

How to create an index on an existing table in ms sql server?

972

What are “lost updates”?

985

What is the difference function and stored procedure?

1042

how would you troubleshoot blocking? : Sql server database administration

973

what is the sql equivaent of the dataset relation object ?

2013

What command do we use to rename a database?

1067

what are constraints? Explain different types of constraints? : Sql server database administration

971

Explain having clause and where clause?

1046

How to change a login name in ms sql server?

1066

between cast and convert which function would you prefer and why?

947

What is the use of set nocount on/off statement?

1086