1. Ligue para os procedimentos armazenados sem 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 ou cmd.execute
setrs = cmd.execute ()
%>
2. Um procedimento armazenado 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. Um parâmetro de entrada e um parâmetro de saída
<%
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. Um parâmetro de entrada, um parâmetro de saída e um 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", 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")
%>
Como ligar para o procedimento armazenado SQL no ASP
www.lucky365.net2002-2-7jiaxiang365
<%setConnection1 = server.createObject ("adodb.connection")
Connection1.open ... 'Junte -se
setCommand1 = server.createObject ("adodb.command")
setCommand1.ActiveConnection = Connection1
Command1.CommandType = 4
Command1.CommandText = "SP_1" 'Nome SP
Command1.parameters (1) = ... 'Valor do parâmetro
command1.parameters (2) = ...
setRecordSet1 = command1.execute ()
%>
Dicas para procedimentos armazenados de chamada ASP
1. O mais simples é o seguinte
DIMOBJCONN
Setobjconn = server.createObject ("Adobd.Connection")
objconn.openApplication ("Connection_string")
'CallThestoredProcEdureToinCrementAcounterOnThePage