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。1つの入力パラメーター、1つの出力パラメーター、および1つの返品値
<%
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")
%>
ASPのSQLストアドプロシージャを呼び出す方法
www.lucky365.net2002-2-7jiaxiang365
<%setConnection1 = server.createObject( "adodb.Connection")
connection1.open ... '結合
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()
%>
ASPコールストアドプロシージャのヒント
1.最も単純なものは次のとおりです
dimobjconn
setobjconn = server.createObject( "adobd.connection")
objconn.openapplication( "connection_string")
'CallTheStoredProceDureToinCrementAcounterThePage