It's possible, but as far as I know you must still do a bit of crazy stuff to get it. Here's one standard example of how it's done with a single SQL statement...

http://techrepublic.com.com/5208-6230-0.html?forumID=88&threadID=168129&messageID=1738104


>In MySQL I can use LIMIT in SQL statement so that I can get that certain data example:
>
> Select * From MyTable LIMIT 10, 20
>
> This statement will return the record 10 to 20 only
>
>Is this possible to MSSQL?