通过游标删除重复数据

declare @max integer,@id nvarchar(max)
declare cur_rows cursor local for select itemcontent,count(*) from 处理重复 group by itemcontent having count(*) > 1
open cur_rows
fetch cur_rows into @id,@max
while @@fetch_status=0
begin
select @max = @max -1
set rowcount @max
delete from 处理重复 where itemcontent = @id
fetch cur_rows into @id,@max
end
close cur_rows
set rowcount 0