<%@ Language=VBScript %>
<%
'---开始链接数据库
Dim strConnString
strConnString = "driver={SQL Server};server=songhp;uid=sa;pwd=;database=XVZDemo"
set Conn = Se***r.CreateObject("AD***.Connection")
Co***Open strConnstring
'---结束链接数据库
'---开始为输入参数赋值
Dim SelectSql , SelectRs
Dim SelectID , SelectName , SelectReturn
SelectSql = "Select Max(CompanyID) From Dim_Company"
Set SelectRs = Co***Execute(SelectSql)
SelectID = SelectRs(0)
'---结束为输入参数赋值
Dim TiggerType
TiggerType = 3
Set Cmd = Se***r.CreateObject("AD***.Command")
Set Cm***ctiveConnection = Conn
Cm***ommandType = 4 '---声明此过程为存储过程
If TiggerType = 1 then
'---开始一个输入参数的存储过程调用
Cm***ommandText = "TransCompany1"
Set CmdParam = Cm***reateParameter("@TransID",3,1)
Cm***arameters.Append CmdParam
Cmd("@TransID") = SelectID
Cm***xecute
'---结束一个输入参数的存储过程调用
Elseif TiggerType = 2 then
'---开始一个输入参数,一个输出参数的存储过程调用
Cm***ommandText = "TransCompany2"
Set CmdParamID = Cm***reateParameter("@TransID",3,1)
Cm***arameters.Append CmdParamID
Cmd("@TransID") = SelectID
Set CmdParamName = Cm***reateParameter("@TransName",202,2,50)
Cm***arameters.Append CmdParamName
Cm***xecute
SelectName = Cmd("@TransName")
'---结束一个输入参数,一个输出参数的存储过程调用
Elseif TiggerType = 3 then
'---开始一个输入参数,一个输出参数,一个返回值的存储过程调用
Cm***ommandText = "TransCompany3"
Set CmdParamReturn = Cm***reateParameter("Return_Value",3,4)
Cm***arameters.Append CmdParamReturn
Set CmdParamID = Cm***reateParameter("@TransID",3,1)
Cm***arameters.Append CmdParamID
Cmd("@TransID") = SelectID
Set CmdParamName = Cm***reateParameter("@TransName",202,2,50)
Cm***arameters.Append CmdParamName
Cm***xecute
SelectName = Cmd("@TransName")
SelectReturn = Cmd("Return_Value")
'---结束一个输入参数,一个输出参数,一个返回值的存储过程调用
End if
Co***Close
Set Conn = Nothing
Set Cmd = Nothing
Set CmdParamID = Nothing
Set CmdParamname = Nothing
Set CmdParamReturn = Nothing
%>
上一篇: 解密ASP源代码