ASP使用存储过程实例
<%
const adInteger=3
const adVarchar=202
const adDBTimeStamp=135
const adCmdStoredProc=4
const adParamInput=1
if request.servervariables("request_method")="post" then
dim strsql
dim conn,studentrs
dim strconn
set conn=server.createobject("adodb.connection")
set cmd=server.createobject("adodb.command")
conn.open"dsn=student;uid=sa;pwd=sa"
set cmd.ActiveConnection=conn
例存储过程:
Create proc dbo.yourProce(@par1 varchar(10),@par2 varchar(2))
as
select * from sysobjects where name = @par1 and type=@par2
go
ASP调用:
set rs=server.createobject("adodb.recordset") rem 创建一个RECORDSET
rs.open "exec dbo.yourProce '"&参数一&"','"&参数二&"'",yourconn rem 执行存储过程
if not rs.eof then
response.write "共找到"&rs.recordcount&"条记录!"
end if
rs.close rem 关闭存储过程
set rs=nothing rem 释放