Q: 表内有重复的记录
A:
A:
select distinct * into # from test
delete test
insert into test select * from #
drop table #
先将内容存入到临时表内,然后再插回去。