Paging On Sql Server Database

It is very simple to do paging on access database (using absolute and pagesize) but I heard its hard to do paging on SQL Server database. How do I do I add simple paging to the fol

Solution 1:

Please see: SQL Server 2005 Paging – The Holy Grail (need to register[free]).