Paging support in T-SQL is not so obvious such as in oracle and mysql, but there's always a way.The below paging mechanism is implemented by PURE T-SQL and is very simple ,the only key is the SET ROWCOUNT keyword.
http://blogs.x2line.com/al/archive/2004/05/29/325.aspx
http://weblogs.sqlteam.com/jeffs/archive/2003/12/22/672.aspx
It's important to remember that SET ROWCOUNT don't order your results in any way ,so to get the expected results, you may use the ORDER BY clause with your SELECT sentences.see http://www.devx.com/getHelpOn/10MinuteSolution/20564