sql2005进行分页的sql语句

SELECT * FROM (
 SELECT *, ROW_NUMBER() OVER (ORDER BY [FriendName]) AS RowNo FROM [Friends]

) AS A WHERE RowNo>@Start AND RowNo<=(@Start+@Count)
-- ORDER BY RowNo




sql2005进行分页的sql语句