实现上千万条数据的分页显示！

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

--获取指定页的数据CREATEPROCEDUREGetRecordFromPage   @tblName      varchar(255),       --表名    @fldName     varchar(255),       --字段名    @PageSize    int=10,           --页尺寸    @PageIndex    int=1,            --页码    @IsCount     bit=0,            --返回记录总数,非0值则返回    @OrderType    bit=0,            --设置排序类型,非0值则降序    @strWhere    varchar(1000)='' --查询条件(注意:不要加where)AS

declare@strSQL  varchar(6000)       --主语句declare@strTmp  varchar(100)        --临时变量declare@strOrdervarchar(400)        --排序类型

if@OrderType!=0begin    set@strTmp="<(selectmin"    set@strOrder="orderby["+@fldName+"]desc"endelsebegin    set@strTmp=">(selectmax"    set@strOrder="orderby["+@fldName+"]asc"end

set@strSQL="selecttop"+str(@PageSize)+"*from["    +@tblName+"]where["+@fldName+"]"+@strTmp+"(["    +@fldName+"])from(selecttop"+str((@PageIndex-1)*@PageSize)+"["    +@fldName+"]from["+@tblName+"]"+@strOrder+")astblTmp)"    +@strOrder

if@strWhere!=''    set@strSQL="selecttop"+str(@PageSize)+"*from["        +@tblName+"]where["+@fldName+"]"+@strTmp+"(["        +@fldName+"])from(selecttop"+str((@PageIndex-1)*@PageSize)+"["        +@fldName+"]from["+@tblName+"]where"+@strWhere+""        +@strOrder+")astblTmp)and"+@strWhere+""+@strOrder

if@PageIndex=1begin    set@strTmp=""    if@strWhere!=''        set@strTmp="where"+@strWhere

    set@strSQL="selecttop"+str(@PageSize)+"*from["        +@tblName+"]"+@strTmp+""+@strOrderend

if@IsCount!=0    set@strSQL="selectcount(*)asTotalfrom["+@tblName+"]" 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>