获取参数过程:
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
ALTER procedure ExGenOrderJl @OrderBillNo varchar(50)
as
Declare @BillGuid uniqueidentifier
Declare @BillMxGuid uniqueidentifier
ASP传递参数程序:
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="Provider = Sqloledb; User ID = " & OutSqlUsername & "; Password = " & OutSqlPassword & "; Initial Catalog = " & OutSqlDatabaseName & "; Data Source = " & OutSqlLocalName & ";"
conn.Open strconn
set cmd.ActiveConnection=conn
cmd.CommandText="{call ExGenOrderJl(?)}"
cmd.Parameters.Append cmd.CreateParameter("@OrderBillNo",adVarchar,adParamInput,50)
cmd("@OrderBillNo")=goods
cmd.Execute()
运行不报错也不能产生结果!
各位大大我这个ASP的参数传递程序要怎么写啊??谢谢了先!
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
ALTER procedure ExGenOrderJl @OrderBillNo varchar(50)
as
Declare @BillGuid uniqueidentifier
Declare @BillMxGuid uniqueidentifier
ASP传递参数程序:
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="Provider = Sqloledb; User ID = " & OutSqlUsername & "; Password = " & OutSqlPassword & "; Initial Catalog = " & OutSqlDatabaseName & "; Data Source = " & OutSqlLocalName & ";"
conn.Open strconn
set cmd.ActiveConnection=conn
cmd.CommandText="{call ExGenOrderJl(?)}"
cmd.Parameters.Append cmd.CreateParameter("@OrderBillNo",adVarchar,adParamInput,50)
cmd("@OrderBillNo")=goods
cmd.Execute()
运行不报错也不能产生结果!
各位大大我这个ASP的参数传递程序要怎么写啊??谢谢了先!
解决方案 »
- foreign keys
- 那位那个看看这个存储过程如何写呢!
- 改变栏位为not null且设Default值 ~~~在线等
- 在delphi中執行存儲過程為甚麼會出現"Timeout expired"?
- 我装完2008,如图 这样是不是正常的
- 谁知道Northwind.Employees.Photo里的数据是什么文件格式?
- 怎样定时执行一个DTS包??
- 我要向数据库里存一篇2.5万中文字的文章,我应该选择什么字段类型?
- 如何在触发器中调用存储过程(sql server 或者 oracle)(无内容)
- 如何将触发器产生的数据写入到指定的文本文件中,不知有谁做过
- 怎么样批量加密所有的存储过程
- 有关 数据的物理结构
asp不懂,
但C#需要指定
da.SelectCommand.CommandType=CommandType.StoreProcedure;
cmd.commandtype=4
cmd.CommandText="ExGenOrderJl"
cmd.Parameters.Append cmd.CreateParameter("@OrderBillNo",adVarchar,adParamInput,50,goods)
cmd.Execute()
conn.execute "exec ExGenOrderJl '" & goods &"'"