1. Calling the stored procedure without parameters <% set conn = server.createObject ("adoDb.connection") set cmd = server.createObject ("adoDb.command") strconn = "DSN = PUBS; UID = SA; PWD" conn .Open strconnection = conncmd.commandtext = "{call nono}" 'set = cmc.exe or cmd.executeSet RS = cmd.execute ()%> 2, a stored procedure of an input parameter <% SET CONN = server.CreateObject ( "adodb.connection") set cmd = server.CreateObject ( "adodb.command") strconn = "dsn = pubs; uid = sa; pwd" conn.Open strconnset cmd.ActiveConnection = conncmd.CommandText = " {Call OneInput (?)} "cmd.parameters.Append cmd.createParameter (" @ aaa ", adINteger, adparaminput) cmd (" @ aaa ") = 100cmd.execute ()%> 3, an input parameter and an output Parameter <% set conn = server.createObject ("adoDb.connection") SET cmd = server.createObject ("adoDb.command") strconn = "DSN = PUBS; UID = SA; PWD" conn.open strconnset cmd.activeConnection = CONNCMD.COMMANDTEXT = "{CALL Oneinout (?,?)}" cmd.parameters.append cmd.createParameter ("@ aaa", adINteger, adParaminput) cmd ("@ aaa") = 10cmd.Parameters.Append cmd.createParameter "@BBB", Adinteger, AdParamoutput) cmd.execute () BBB = cmd ("@ bbb")%> 4 , An input parameter, an output parameter, and a return value <% set conn = server.createObject ("adoDb.connection") SET cmd = server.createObject ("adoDb.command") strconn = "DSN = Pubs; uid = SA; PWD "conn.open strandnset cmd.activeconnection = conncmd.commandtext =" {? = call onereturn (?,?)} "cmd.parameters.Append cmd.createParameter (" @ return_value "
