求P_viewPage这个sql2000分页存储在asp文件中如何调用到统计数量
本帖最后由 zxl9988 于 2012-11-27 19:54:26 编辑 [ P_viewPage] 的 sql2000分页存储代码网上很多，（代码如下，我用sql查询分析器，看了下，只有查询原表内容，而没有TotalCount，请问在asp具体文件中怎么能调用TotalCount数量，
或能不能给我一个P_viewPage分页的asp调用程序
这个问题提了好久，到目前还没能解决

ALTER?PROC?[dbo].[P_viewPage] 

--?Add?the?parameters?for?the?stored?procedure?here 

@TableName?VARCHAR(200),?????--表名 

@FieldList?VARCHAR(2000),????--显示列名，如果是全部字段则为* 

@PrimaryKey?VARCHAR(100),????--单一主键或唯一值键 

@Where?VARCHAR(2000),????????--查询条件?不含'where'字符，如id>10?and?len(userid)>9 

@Order?VARCHAR(1000),????????--排序?不含'order?by'字符，如id?asc,userid?desc，必须指定asc或desc 

--注意当@SortType=3时生效，记住一定要在最后加上主键，否则会让你比较郁闷 

@SortType?INT,???????????????--排序规则?1:正序asc?2:倒序desc?3:多列排序方法 

@RecorderCount?INT,??????????--记录总数?0:会返回总记录 

@PageSize?INT,???????????????--每页输出的记录数 

@PageIndex?INT,??????????????--当前页数 

@TotalCount?INT?OUTPUT,??????--记返回总记录 

@TotalPageCount?INT?OUTPUT???--返回总页数 

AS

--?SET?NOCOUNT?ON?added?to?prevent?extra?result?sets?from 

--?interfering?with?SELECT?statements. 

SET?NOCOUNT?ON

IF?ISNULL(@TotalCount,'')?=?''?SET?@TotalCount?=?0 

SET?@Order?=?RTRIM(LTRIM(@Order)) 

SET?@PrimaryKey?=?RTRIM(LTRIM(@PrimaryKey)) 

SET?@FieldList?=?REPLACE(RTRIM(LTRIM(@FieldList)),'?','') 

WHILE?CHARINDEX(',?',@Order)?>?0?OR?CHARINDEX('?,',@Order)?>?0 

BEGIN

SET?@Order?=?REPLACE(@Order,',?',',') 

SET?@Order?=?REPLACE(@Order,'?,',',') 

END

IF?ISNULL(@TableName,'')?=?''?OR?ISNULL(@FieldList,'')?=?''

OR?ISNULL(@PrimaryKey,'')?=?''

OR?@SortType?<?1?OR?@SortType?>3 

OR?@RecorderCount?<?0?OR?@PageSize?<?0?OR?@PageIndex?<?0 

BEGIN

???PRINT('ERR_00参数错误') 

???RETURN

END

IF?@SortType?=?3 

BEGIN

IF?(UPPER(RIGHT(@Order,4))!='?ASC'?AND?UPPER(RIGHT(@Order,5))!='?DESC') 

BEGIN

???PRINT('ERR_02排序错误')?RETURN?END

END

DECLARE?@new_where1?VARCHAR(1000) 

DECLARE?@new_where2?VARCHAR(1000) 

DECLARE?@new_order1?VARCHAR(1000) 

DECLARE?@new_order2?VARCHAR(1000) 

DECLARE?@new_order3?VARCHAR(1000) 

DECLARE?@Sql?VARCHAR(8000) 

DECLARE?@SqlCount?NVARCHAR(4000) 

IF?ISNULL(@where,'')?=?''

BEGIN

SET?@new_where1?=?'?'

SET?@new_where2?=?'?WHERE?'

END

ELSE

BEGIN

SET?@new_where1?=?'?WHERE?'?+?@where

SET?@new_where2?=?'?WHERE?'?+?@where?+?'?AND?'

END

IF?ISNULL(@order,'')?=?''?OR?@SortType?=?1?OR?@SortType?=?2 

BEGIN

IF?@SortType?=?1 

???BEGIN

???SET?@new_order1?=?'?ORDER?BY?'?+?@PrimaryKey?+?'?ASC'

???SET?@new_order2?=?'?ORDER?BY?'?+?@PrimaryKey?+?'?DESC'

???END

IF?@SortType?=?2 

???BEGIN

???SET?@new_order1?=?'?ORDER?BY?'?+?@PrimaryKey?+?'?DESC'

???SET?@new_order2?=?'?ORDER?BY?'?+?@PrimaryKey?+?'?ASC'

???END

END

ELSE

BEGIN

SET?@new_order1?=?'?ORDER?BY?'?+?@Order

END

IF?@SortType?=?3?AND?CHARINDEX(','+@PrimaryKey+'?',','+@Order)>0 

BEGIN

SET?@new_order1?=?'?ORDER?BY?'?+?@Order

SET?@new_order2?=?@Order?+?','

SET?@new_order2?=?REPLACE(REPLACE(@new_order2,'ASC,','{ASC},'),'DESC,','{DESC},') 

SET?@new_order2?=?REPLACE(REPLACE(@new_order2,'{ASC},','DESC,'),'{DESC},','ASC,') 

SET?@new_order2?=?'?ORDER?BY?'?+?SUBSTRING(@new_order2,1,LEN(@new_order2)-1) 

IF?@FieldList?<>?'*'

???BEGIN

???SET?@new_order3?=?REPLACE(REPLACE(@Order?+?',','ASC,',','),'DESC,',',') 

???SET?@FieldList?=?','?+?@FieldList 

???WHILE?CHARINDEX(',',@new_order3)>0&