how to use a select statement to return the first 250,000 records

[tmartin99]

Does anyone know how to use just a select statement to
1. return the first 250,000 records from a table, then
2. return the next 250,000 records from a table.
on subsequent runs of the sql script?

 

[mingus]

select top 100 * from table

Selects the top 100.

If you say:

select top 100 * from table order by id

You'd get the first 100, then say:

select top 100 * from table where id > 100 order by id

You'd get the next 100, assuming all your ids are present.
Of course you'd really want to get the max value from the first select and use that in your where clause.

my 2 cents

mingus

 

[tmartin99]

Does SQL Server not have rowid's like Oracle?

in Oracle you can say:

select rowid from dual;