asp中使用简单的存储过程

由先在sqlserver中建立存储过程dbo.proa

CREATE PROCEDURE dbo.proa
@ini char(10)
as
select aa from a where aa=@ini
GO
能后在asp中写入语句

<!--#include file=conn.asp-->
<!--#include file="adovbs.inc"-->
<%
dim ini
ini="11"
set rs=server.createobject("adodb.recordset")

set comm=server.createobject("adodb.command")
comm.commandtype=4
comm.Parameters.append comm.CreateParameter("@ini",adChar,adParamInput,50,ini)
'comm.Parameters.append comm.CreateParameter("@keyword",adInteger,adParamInput,,choose)
set comm.activeconnection=conn
comm.commandtext="dbo.proa"
set rs=server.createobject("adodb.recordset")
rs.CursorType=3
rs.open comm,,1,1

'sql="exec dbo.proa"&ini
'rs.open sql,Conn,1,1
response.write rs.recordcount
%>

运行测试.