时间: 2021-07-31 作者:daque
1,挪用没有参数的保存进程<%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 nono}"'set rs=cmc.exe 大概cmd.executeset rs=cmd.execute()%>2,一个输出的参数的保存进程<%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,一个输出参数和一个输入的参数<%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,一个输出参数,一个输入参数,和一个归来值<%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 onereturn(?,?)}"cmd.parameters.append cmd.createparameter("@return_value",adinteger,adparamreturnvalue )cmd.parameters.append cmd.createparameter("@aaa",adinteger,adparaminput )cmd("@aaa")=10cmd.parameters.append cmd.createparameter("@bbb",adinteger,adparamoutput)cmd.execute()bbb=cmd("@bbb")rrr=cmd("@return_value")%>