这样调用存储过程为何不能显示数据呢？
[b]我写了个简单的存储过程 如下：[/b][color=Gray]CREATE PROCEDURE product_info
@inID int
AS
select id,categoryid,category from CATEGORY where id=@inID
GO[/color]
[b]但是调用时没有任何反应，是什么原因？
调用方式如下[/b]
[color=Gray]dim myid
myid=2
response.write "myid="&myid&"<br/>"
strsql="product_info"&myid
set rs=conn.execute(strsql)
response.write "ID:"&rs(0)&" | "&"名称:"&rs(1)
rs.close
set rs=nothing[/color]
@inID int
AS
SET NOCOUNT ON
select id,categoryid,category from CATEGORY where id=@inID
GO
页:
[1]