[转]一个利用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
