下面的SQL语句可以去除数据库中重复的记录,这只是一个模板,只需修改红色的地方就可以了
declare @max integer,@name nvarchar(255)
declare cur_rows cursor local for select 标题字段名,count(*) from 表名 group by 标题字段名 having count(*) > 1
open cur_rows
fetch cur_rows into @name,@max
while @@fetch_status=0
begin
select @max = @max -1
set rowcount @max
delete from 表名 where 标题字段名 = @name
fetch cur_rows into @name,@max
end
close cur_rows
set rowcount 0