请问存储过程的问题,谢谢!
我想从存储过程中输出一个参数,是这样写的:
CREATE PROCEDURE dbo.PRO_pageview
(
@tint_tableid int=1,
@int_pagenow int=0,
@int_pagesize int=0,
@int_recordcount int=0 output
)
as
select @int_allid=count(*) from bbs_10 where layer=1
select @int_recordcount=@int_allid
select top 100 * from bbs_10
go
然后用asp取出int_recordcount的值:
set cmd=server.CreateObject("adodb.command")
cmd.ActiveConnection=conn
cmd.CommandType=4
cmd.CommandText="pro_pageview"
cmd.Parameters.Append cmd.CreateParameter("int_recordcount",adInteger,adParamOutput)
set rs=cmd.Execute
recordcount=cmd.Parameters("int_recordcount")
Response.Write recordcount
可输出来的值是空,请问错在哪?该怎么写,谢谢!