Command 示例

存储过程代码

输入两个实数,输出两个值,分别为它们的 和/积。

CREATE PROCEDURE [dbo].[test1] 
@num3 real OUTPUT,
@num4 real OUTPUT,
@num1 real = 20.0,
@num2 real = 10.0
AS
set @num3 = @num1 + @num2
set @num4 = @num1 * @num2
GO

ASP 代码调用

Public Const adDouble = 5
Public Const AdParamInput = 1
Public Const AdParamOutput = 2
Public Const adCmdStoredProc = 4

set cn = server.createobject("adodb.connection")
cn.open "DRIVER={SQL Server};SERVER=localhost;DATABASE=asteras;Trusted_Connection=yes"

set cmd = server.createobject("adodb.command")
cmd.CommandText = "test1"
cmd.CommandType = adCmdStoredProc
set cmd.activeconnection = cn
set p = cmd.CreateParameter ("@num1", adDouble, AdParamInput, 8, 123.0 ) 
cmd.parameters.append p
set p = cmd.CreateParameter ("@num2", adDouble, AdParamInput, 8, 2.0 ) 
cmd.parameters.append p
set p = cmd.CreateParameter ("@num3", adDouble, AdParamOutput, 8, 0.0 ) 
cmd.parameters.append p
set p = cmd.CreateParameter ("@num4", adDouble, AdParamOutput, 8, 0.0 ) 
cmd.parameters.append p
cmd.execute

response.write cmd.parameters("@num3").value
response.write cmd.parameters("@num4").value
cn.close