CREATEPROCEDURE GetRecordFromPage @tblNamevarchar(255), -- 表名 @fldNamevarchar(255), -- 字段名 @PageSizeint=10, -- 页尺寸 @PageIndexint=1, -- 页码 @IsCountbit=0, -- 返回记录总数, 非 0 值则返回 @OrderTypebit=0, -- 设置排序类型, 非 0 值则降序 @strWherevarchar(1000) =''-- 查询条件 (注意: 不要加 where) AS declare@strSQLvarchar(1000) -- 主语句 declare@strTmpvarchar(300) -- 临时变量 declare@strOrdervarchar(400) -- 排序类型 if@OrderType!=0 begin set@strTmp='<(select min' set@strOrder=' order by ['+@fldName+'] desc' end else begin set@strTmp='>(select max' set@strOrder=' order by ['+@fldName+'] asc' end set@strSQL='select top '+str(@PageSize) +' * from [' +@tblName+'] where ['+@fldName+']'+@strTmp+'([' +@fldName+']) from (select top '+str((@PageIndex-1)*@PageSize) +' [' +@fldName+'] from ['+@tblName+']'+@strOrder+') as tblTmp)' +@strOrder if@strWhere!='' set@strSQL='select top '+str(@PageSize) +' * from [' +@tblName+'] where ['+@fldName+']'+@strTmp+'([' +@fldName+']) from (select top '+str((@PageIndex-1)*@PageSize) +' [' +@fldName+'] from ['+@tblName+'] where ('+@strWhere+') ' +@strOrder+') as tblTmp) and ('+@strWhere+') '+@strOrder if@PageIndex=1 begin set@strTmp='' if@strWhere!='' set@strTmp=' where ('+@strWhere+')' set@strSQL='select top '+str(@PageSize) +' * from [' +@tblName+']'+@strTmp+''+@strOrder end if@IsCount!=0 set@strSQL='select count(*) as Total from ['+@tblName+']' exec (@strSQL) GO