存贮过程的返回参数为什么老返回最后一个select语句的记录总个数

[innerfire]

存贮过程如下：

CREATE PROCEDURE ud_SplitUserFromSearch
(@nStartRow int,
@nEndRow int,
@strSql varchar(300),
@nCount int output
)
AS
set nocount on
create table ##t_table
(
[rownum][int] IDENTITY(1,1) Primary Key NOT NULL,
[UserID] [int] NOT NULL ,
[UserType] [int] NOT NULL ,
[Nickname] [varchar] (50) NOT NULL ,
[Sex] [int] NOT NULL ,
[Province] [varchar] (20) NOT NULL ,
[Addr] [varchar] (100) NOT NULL ,
[Postalcode] [varchar] (10) NOT NULL ,
[Birthday] [datetime] NOT NULL ,
[certificateType] [varchar] (50) NOT NULL ,
[CertificateCode] [varchar] (60) NOT NULL ,
[Mail] [varchar] (50) NOT NULL ,
[UserWork] [varchar] (100) NOT NULL ,
[Income] [varchar] (50) NOT NULL ,
[Name] [varchar] (50) NOT NULL ,
[Description] [varchar] (300) NULL ,
[Tele] [varchar] (100) NOT NULL ,
[Password] [varchar] (50) NOT NULL ,
[Portrait] [varchar] (300) NULL ,
[Body] [varchar] (100) NULL ,
[Height] [int] NULL ,
[MarryState] [varchar] (100) NOT NULL ,
[Education] [varchar] (100) NOT NULL ,
[Rate] [varchar] (100) NOT NULL ,
[Purpose] [varchar] (100) NOT NULL ,
[Interesting] [varchar] (300) NULL ,
[Character] [varchar] (300) NULL ,
[Fashion] [varchar] (300) NULL ,
[MobileCode] [varchar] (50) NOT NULL ,
[InputTime] [datetime] NULL ,
[HeadImage] [varchar] (100) NULL ,
[Hot] [int] NULL
)

set RowCount @nEndRow

exec ('insert ##t_table
(
[UserID],
[UserType],
[Nickname],
[Sex],
[Province],
[Addr],
[Postalcode],
[Birthday],
[certificateType],
[CertificateCode],
[Mail] ,
[UserWork],
[Income] ,
[Name] ,
[Description],
[Tele] ,
[Password] ,
[Portrait] ,
[Body] ,
[Height] ,
[MarryState],
[Education],
[Rate],
[Purpose],
[Interesting],
[Character],
[Fashion],
[MobileCode],
[InputTime],
[HeadImage],
[Hot]
)' +@strSql )

select @nCount=count(*) from ##t_table
SELECT * FROM ##t_table WHERE rownum >= @nStartRow and rownum<=@nEndRow
ORDER BY rownum

drop table ##t_table
set nocount off
GO


在VB中用command对象调用该过程

在取command("nCount").value时总是取得是存储过程返回的记录集的记录个数
可我要的是总个数啊，请高手解答！！

[zosky]

SELECT * FROM ##t_table WHERE rownum >= @nStartRow and rownum<=@nEndRow
ORDER BY rownum
这一句去掉

[caiyunxia]

@nCount int output是返回直
有前台游标，接返回的记录集

[innerfire]

楼上的能说详细点么？
存贮过程中的返回值不能在存贮过程返回记录集的情况下返回么？
那传入传出值可以不可以？
还有如果用游标要怎么用？
谢谢

[txlicenhe]

若要用存贮过程返回记录集，不要用output，而在存贮过程的最后写一条select语句。
create procedure test
As
select * from sysobjects


VB中:
dim rs as new adodb.recordset
rs.open " exec test "
即可