sql2000分页问题???????????????????????

select * from(select ROW_NUMBER() over({1}) as rowNumber, t.* from ({0}) t) tempTable where rowNumber between {2} and {3} ", sql, orderby, startRow, endRow)
sql2005有函数ROW_NUMBER()，如何改成sql2000

http://www.cnblogs.com/skylaugh/archive/2012/05/04/2482738.html

http://www.cnblogs.com/newsea/archive/2009/08/22/1552214.html