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 edit table in sql server 2017?

514

How to find the login name linked to a given user name?

534

Can we join two tables without primary key?

619

Is candidate a key?

536

How to download and install the scaled-down database adventureworkslt?

608

Can foreign key be duplicate?

632

What is mean by candidate key?

542

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

498

Where do you find the default Index fill factor and how to change it?

604

How to reaname table name without using sp_Rename in sql server..?

530

What is a fill factor?

627

Define model database?

576

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

596

Can I delete event logs?

546

How to create function without parameter in sql server?

561