asp存储过程使用大全.doc

asp 存储过程使用大全

1，调用没有参数的存储过程

<%

set conn=server.CreateObject("adodb.connection")

set cmd=server.CreateObject("adodb.command")

strconn="dsn=pubs;uid=sa;pwd"

conn.Open strconn

<%

set conn=server.CreateObject("adodb.connection")

set cmd=server.CreateObject("adodb.command")

strconn="dsn=pubs;uid=sa;pwd"

conn.Open strconn

set cmd.ActiveConnection=conn

cmd.CommandText="{call oneinput(?)}" cmd.Parameters.Append cmd.CreateParameter(

"@aaa",adInteger ,adParamInput )

cmd("@aaa")=100

cmd.Execute()

conn.Open strconn

set cmd.ActiveConnection=conn

cmd.CommandText = "{call oneinout(?,?)}" cmd.Parameters.Append cmd.CreatePara

meter("@aaa",adInteger,adParamInput)

cmd("@aaa")=10 cmd.Parameters.Append cmd.CreateParameter("@bbb",adInteger,adPara

mOutput)

cmd.Execute()

bbb=cmd("@bbb")

%>

4，一个输入参数，一个输出参数，和一个返回值