求助,救记录总数的存储过程该怎么写? 求一个简短存储过程示例和asp调用存储过程的简单程序,谢谢了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create proc up_getcountasselect count(*) from 表名 CREATE PROCEDURE 存储过程名 (@table_name varchar(50)) ASselect count(*) from 表名GOexec 存储过程+你的表名 CREATE PROCEDURE dbo.blog_test@tbname sysname,@RecdCount int outputAS declare @SQL varchar(1000) SET @SQL='SELECT @RecdCount=COUNT(*) FROM '+@tbname EXEC sp_executesql @SQL,'@RecdCount int OUTPUT',@RecdCount OUTPUT SET @RecdCount=@RecdCountGOasp调用时出错,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.ExecuteResult = 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 求SQL语句:存在就跳过,不存在就插入记录,从字段ID=1开始,到字段ID=1某个值结束? 统计 菜鸟求 SQL:关于分类求和 为什么进不了事件探查器,总是提示SQL不存在或者访问被拒绝? 是否存在这样的SQL语句? 高手进 查询连续N天记录 这样的 sql 查询有谁会写?100分 修改WINDOWS 2000的密码后,SQL 2000启动就会失败,请问如何解决 这么简单的问题也没人回答?pengdali(大力) 大哥在吗,帮帮我? 使用存储过程将客户查询导入到excel中 简单的sql语句 纵向变横向
as
select count(*) from 表名
@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