You're dreaming <s>
Seriously, there is nothing native in the SQL Server execution engine that supports paging. It's something that you'll have to implement yourself. It's a complex problem that I have yet to see, or figure out, a good answer to.
-Mike