求助，救记录总数的存储过程该怎么写？

[almims]

求一个简短存储过程示例和asp调用存储过程的简单程序，谢谢了。

[almims]

试了一上午还是不行。。。

[gahade]

create proc up_getcount
as
select count(*) from 表名

[jwda7sgr]

CREATE PROCEDURE 存储过程名 (@table_name varchar(50)) AS

select count(*) from 表名

GO

exec 存储过程＋你的表名

[almims]

CREATE PROCEDURE dbo.blog_test
@tbname sysname,
@RecdCount int output
AS
declare @SQL varchar(1000)
SET @SQL='SELECT @RecdCount=COUNT(*) FROM '+@tbname
EXEC sp_executesql @SQL,'@RecdCount int OUTPUT',@RecdCount OUTPUT
SET @RecdCount=@RecdCount
GO


asp调用时出错，

adCmdSPStoredProc = 4
adParamReturnValue = 4
adParamInput = 1
adParamOutput = 2
adInteger = 3
adVarchar = 200
adDateTime=8
tbname = "user_article"
fieldkey = "article_id"

Set MyComm = Server.CreateObject("ADODB.Command")
MyComm.ActiveConnection = Conn_Blog
MyComm.CommandText = "blog_test"
MyComm.CommandType = 4
MyComm.Prepared = true
MyComm.Parameters.Append MyComm.CreateParameter("@tbname",adVarchar,adParamInput,128,tbname)
MyComm.Parameters.Append MyComm.CreateParameter("@RecdCount",adInteger,adParamOutput,,Result)
Set rs = MyComm.Execute
Result = MyComm.Parameters("@Result")
Set MyComm = Nothing
Response.Write("RecdCount："& Result &"<br>")


Microsoft OLE DB Provider for SQL Server 错误 '80040e14'

过程需要参数 '@statement' 为 'ntext/nchar/nvarchar' 类型。

/test.asp，行22