ASP调用存储过程问题
我有一个存储过程AGJBRN，内容是执行一些关联和计算后，返回筛选过的数据.
最后是这样的:
CREATE PROCEDURE dbo.AGJBRN AS
set nocount on
…………………………
if exists (Select * From sysobjects where name= 'AGJBR ' and xtype= 'U ')
drop table AGJBR
select * into AGJBR from #AGJ10
GO
就是把记录放到一个表AGJBR中去。
现在我想在网页中执行这个存储过程，然后显示AGJBR这个表，要怎样做呢？
[解决办法]
set rs=conn.execute( "execute name ")
括号里面是执行过程那个命令,我忘记了
[解决办法]
CREATE PROCEDURE dbo.AGJBRN AS
set nocount on
…………………………
if exists (Select * From sysobjects where name= 'AGJBR ' and xtype= 'U ')
drop table AGJBR
select * into AGJBR from #AGJ10
select * FROM AGJBR
GO
ASP:
Set oCnn = CreateObject( "ADODB.Connection ")
oCnn.Open SQLConnection
Set oCommand = CreateObject( "ADODB.Command ")
oCommand.CommandText = "AGJBRN "
oCommand.CommandType = 4
Set .ActiveConnection = oCnn
Set oRS= oCommand.Execute
Set .ActiveConnection = Nothing
Do While Not oRS.EOF
...
Loop
Set oCommand = Nothing
oRS.Close
Set oRS = Nothing
