删除没有主键的表中的重复记录

create procedure delrepeat

as
begin
SELECT distinct *  INTO testTemp FROM test
delete from test
insert into test SELECT *  FROM testTemp
drop table testTemp
end

distinct:用于查询中去除重复项

begin~end范围语句表示存储过程中作为整体执行的语句块