你可以在你的防火墙产生的记录表里面加一个自增长的字段id,然后就可以随意取多少行来处理了。如 select * from yourtable where id between 1000 and 2000
如果表里面的记录主要以入侵记录为主,可以这样操作: 修改当前这个表名tablename-->anothername 新增一个表tablename insert tablename select * from anothername where condition is true
使用临时表 select identity(int,1,1) as ID,* into #tmp from yourtable--numbera,numberb 可以任意设定为某一区间 select * from #tmp where id between numbera and numberbdrop table #tmp
可以加一个自增字段再处理。alter table 表名 add id int identity(1,1)
select top 1000 * into 临时表 from 表
select * from yourtable where id between 1000 and 2000
修改当前这个表名tablename-->anothername
新增一个表tablename
insert tablename select * from anothername where condition is true
select identity(int,1,1) as ID,*
into #tmp
from yourtable--numbera,numberb 可以任意设定为某一区间
select * from #tmp where id between numbera and numberbdrop table #tmp