因为表中没有主键,所以会有重复记录出现。下面语句可以删除重复记录
use MyTest
select distinct * into # from voter
truncate table voter
insert voter select * from #
drop table #
因为表中没有主键,所以会有重复记录出现。下面语句可以删除重复记录
use MyTest
select distinct * into # from voter
truncate table voter
insert voter select * from #
drop table #