select distinct * into #t from tb
truncate table tb
insert into tb select * from #t
一条sql语句效率比较低,建临时表效率比较高些
create table mayong as (select distinct* from sms.vehicle);
delete from sms.vehicle ;
insert into sms.vehicle select * from mayong;
select distinct * into #t from tb
truncate table tb
insert into tb select * from #t
一条sql语句效率比较低,建临时表效率比较高些
create table mayong as (select distinct* from sms.vehicle);
delete from sms.vehicle ;
insert into sms.vehicle select * from mayong;