select distinct * into temptable from tableA
truncate table tableA
insert into tableA select * from temptable
或者
alter table tableA add ID_NEW int identity
go
delete a from tableA a where exists(select 1 from tableA where Name=a.name and ID_NEW>a.ID_NEW)
go
alter table tableA drop column ID_NEW
