建立存储过程序：

CREATE procedure [dbo].[my_query]
@id int,
@title varchar(60) output,
@typeid int output
as
select @title=title,@typeid=typeid from news where id=@id

ASP中的程序

set conn= Server.CreateObject("adodb.connection")
conn.Open "Driver={SQL Server};Server=localhost;Database=news;Uid=sa;Pwd=sa"

set cmd= Server.CreateObject("adodb.command")
cmd.activeconnection=conn
cmd.commandtype=4
cmd.commandtext="my_query"
cmd.Parameters.Append cmd.CreateParameter("@id",200,1,10,5)
cmd.Parameters.Append cmd.CreateParameter("@title",200,2,10)
cmd.Parameters.Append cmd.CreateParameter("@typeid",200,2,10)
cmd.execute
response.write Cmd("@title")