有id:
select * from table1 where id>=100 and id<=200
无id临时表:
select id=identity(int,1,1),* into temp from table1
select * from temp where id>=100 and id<=200
drop table temp
select * from table1 where id>=100 and id<=200
无id临时表:
select id=identity(int,1,1),* into temp from table1
select * from temp where id>=100 and id<=200
drop table temp
select * from #tb where id between (x-1)*y and x*y-1