declare @a int
declare @b int
declare @total int
select @a =11375038
select @b =11395038
while @b< 164049168--164049168
begin
select @a=@a+20000
select @b=@b+20000
select @total=(select count(*) from [Archiveaaaaa] where siteid= 564 and id between @a and @b)
print @total
delete from [Archiveaaaaa] where siteid= 564 and id between @a and @b
print '删除成功'
end
