1. Llame a los procedimientos almacenados sin parámetros
<%
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 o cmd.execute
setrs = cmd.execute ()
%>
2. Un procedimiento almacenado para parámetros de entrada
<%
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. Un parámetro de entrada y un parámetro de salida
<%
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. Un parámetro de entrada, un parámetro de salida y un valor de retorno
<%
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", adintager, 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")
%>
Cómo llamar al procedimiento almacenado SQL en ASP
www.lucky365.net2002-2-7jiaxiang365
<%setconnection1 = server.createObject ("ADODB.Connection")
conexión1.Apen ... 'Únete
setCommand1 = Server.CreateObject ("ADODB.COMMAND")
setCommand1.Activeconnection = Connection1
comando1.CommandType = 4
comando1.CommandText = "SP_1" 'Nombre SP
comando1.parameters (1) = ... 'Valor del parámetro
comando1.parameters (2) = ...
setRecordSet1 = command1.execute ()
%>
Consejos para los procedimientos almacenados ASP llamando a ASP
1. El más simple es el siguiente
Dimobjconn
Setobjconn = server.createObject ("Adobd.Connection")
objconn.openapplication ("Connection_String")
'CallThestoredRoreduretoincrementCounTeronthepage