[转]一个利用Sql Server 20005的 ROW_NUMBER Function 的分页存储过程.
摘要：
ROW_NUMBER returns a sequential number, starting at 1, for each row returned in a resultset.CREATE PROCEDURE dbo.ShowLog @PageIndex INT, @PageSize INT ASBEGIN WITH LogEntries AS ( SELECT ROW_NUMBER()... 阅读全文
posted @ 2006-05-11 16:28 SysInfo 阅读(561) 评论(0) 推荐(0) 编辑