1. Вызовите хранимые процедуры без параметров
<%
setConn = server.createObject ("adodb.connection")
setCmd = server.createObject ("adodb.command")
strconn = "dsn = pubs; uid = sa; pwd"
Conn.openstrconn
setCmd.ActiveConnection = conn
cmd.commandtext = "{callnono}"
'setrs = cmc.exe или cmd.execute
setrs = cmd.execute ()
%>
2. Хранитованная процедура для входных параметров
<%
setConn = server.createObject ("adodb.connection")
setCmd = server.createObject ("adodb.command")
strconn = "dsn = pubs; uid = sa; pwd"
Conn.openstrconn
setCmd.ActiveConnection = conn
cmd.commandtext = "{calloneinput (?)}"
cmd.parameters.appendcmd.createparameter ("@aaa", Adinteger, Adparaminput)
cmd ("@aaa") = 100
cmd.execute ()
%>
3. Входной параметр и выходной параметр
<%
setConn = server.createObject ("adodb.connection")
setCmd = server.createObject ("adodb.command")
strconn = "dsn = pubs; uid = sa; pwd"
Conn.openstrconn
setCmd.ActiveConnection = conn
cmd.commandtext = "{calloneinout (?,?)}"
cmd.parameters.appendcmd.createparameter ("@aaa", Adinteger, Adparaminput)
cmd ("@aaa") = 10
cmd.parameters.appendcmd.createparameter ("@bbb", adinteger, adparamoutput)
cmd.execute ()
bbb = cmd ("@bbb")
%>
4. Один входной параметр, один выходной параметр и одно возвратное значение
<%
setConn = server.createObject ("adodb.connection")
setCmd = server.createObject ("adodb.command")
strconn = "dsn = pubs; uid = sa; pwd"
Conn.openstrconn
setCmd.ActiveConnection = conn
cmd.commandtext = "{? = callonereturn (?,?)}"
cmd.parameters.appendcmd.createParameter ("@return_value", Adinteger, AdparamreturnValue)
cmd.parameters.appendcmd.createparameter ("@aaa", Adinteger, Adparaminput)
cmd ("@aaa") = 10
cmd.parameters.appendcmd.createparameter ("@bbb", adinteger, adparamoutput)
cmd.execute ()
bbb = cmd ("@bbb")
rrr = cmd ("@return_value")
%>
Как вызвать хранимую процедуру SQL в ASP
www.lucky365.net2002-2-7jiaxiang365
<%setConnection1 = server.createObject ("adodb.connection")
Connection1.open ... 'Join
setCommand1 = server.createObject ("adodb.command")
setCommand1.activeConnection = connection1
command1.commandtype = 4
command1.commandtext = "sp_1" 'sp name
Command1.parameters (1) = ... 'Значение параметра
Command1.parameters (2) = ...
setRecordSet1 = command1.execute ()
%>
Советы по вызову сохраненных процедур
1. Самый простой - это следующее
Dimobjconn
Setobjconn = server.createObject ("Adobd.connection")
objconn.openapplication ("connection_string")
'CallthestoredProcedUretoIncrementAcounterThePeage