select distinct * into temptable from tablename
gotruncate table tablename
goinsert tablename
select * from temptable
godrop table temptable
go
gotruncate table tablename
goinsert tablename
select * from temptable
godrop table temptable
go
除了这种方法以外还有什么解决办法?因为库里的数据较多,用临时表有点慢
谢谢!
这条语句在效果上等同于delete from yourTable
但是delete语句是写日志的,而truncate语句不写日志,因此要快得多。
select distinct * from tablename;
/
truncate table tablename;
/
insert into tablename
select * from newTable;
/
drop table newTable;
/