28,406
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
sunxy01 2005-06-01
- 打赏
- 举报
CREATE PROCEDURE [Count_tebookscat]
@nTotal [int] OUTPUT,
@ID [int]
AS
set nocount on
Select @nTotal=count(*) from cat where ID=@ID
set nocount off
RETURN @nTotal
GO
asp
set cmd =server.CreateObject("adodb.command")
cmd.ActiveConnection=conn
cmd.CommandText="Count_tebookscat"
cmd.CommandType=4
set Para1=cmd.CreateParameter("Total",adInteger,adParamReturnValue)
cmd.Parameters.Append Para1
set Para2=cmd.CreateParameter("@ID",3,1,4,temp)
cmd.Parameters.Append Para2
set rs2=cmd.execute
set cmd=nothing
nCount=rs2("@nTotal")
@nTotal [int] OUTPUT,
@ID [int]
AS
set nocount on
Select @nTotal=count(*) from cat where ID=@ID
set nocount off
RETURN @nTotal
GO
asp
set cmd =server.CreateObject("adodb.command")
cmd.ActiveConnection=conn
cmd.CommandText="Count_tebookscat"
cmd.CommandType=4
set Para1=cmd.CreateParameter("Total",adInteger,adParamReturnValue)
cmd.Parameters.Append Para1
set Para2=cmd.CreateParameter("@ID",3,1,4,temp)
cmd.Parameters.Append Para2
set rs2=cmd.execute
set cmd=nothing
nCount=rs2("@nTotal")
seabee 2005-05-27
- 打赏
- 举报
Up
seabee 2005-05-18
- 打赏
- 举报
是输出变量。上面打错字了。
seabee 2005-05-18
- 打赏
- 举报
用MS SQL SERVER 2000的~~
select count(1) as rowcout from table
但是我不会在存储过程里面用输入变量。。。请问怎么用啊？
select count(1) as rowcout from table
但是我不会在存储过程里面用输入变量。。。请问怎么用啊？
fengfangfang 2005-05-18
- 打赏
- 举报
select count(*) as rowcount from tablename
另外，你用的数据库是什么，可能有更好的办法
另外，你用的数据库是什么，可能有更好的办法
