SQL 2005 ROW_NUMBER() 存储过程分页

create PROCEDURE [dbo].[ShowPage]
@strSQL		varchar(max) = '',		-- 如：'a.UserName,a.Password,b.id from Users a left join Roles b on a.id=b.id where a.id>0'
@strOrder	varchar(max) = '',		-- 排序的字段名 如：'a.id desc,a.AddTime desc'
@PageSize	int = 10,				-- 页尺寸
@PageIndex	int = 1					-- 页码
AS

declare @ExecSQL   varchar(max)

set @ExecSQL='SELECT * FROM (SELECT ROW_NUMBER() OVER ( ORDER BY ' + @strOrder + ') AS pos,' + @strSQL + ') AS sp WHERE pos BETWEEN '+str((@PageIndex-1)*@PageSize+1)+' AND '+str(@PageIndex*@PageSize)
--print @ExecSQL
exec (@ExecSQL)