I want to limit the number of rows returned by a
select statement. For instance, I would like to be able to
retrieve the records from a select statement in blocks of, lets say
100 records: the first select would return the records 1 to 100,
the second, records 101 to 200, etc.
I know that Oracle has a "rownum" expression that we can use in
a where clause, but could not find anything similar for sql server.