问一下ASP调用存储的正确语法，我写的老是调用出错
存储过程
create procedure pro_feibiao
as
declare @cur_col varchar(30)
declare @bi_id varchar(50)
declare @sql varchar(1000)
declare cur_col cursor for
select b.name from sysobjects a ,syscolumns b
where a.name = 'bid_item ' and a.id = b.id and colid between 28 and (select

top 1 colid from sysobjects a ,syscolumns b
where a.name = 'bid_item ' and a.id = b.id
order by colid desc) order by colid
open cur_col

fetch next from cur_col into @cur_col
while @@fetch_status = 0

BEGIN

set @sql= ' '
set @sql= 'update bid_item set ' ' '+@cur_col+ ' ' '=null where bi_id=@bi_id '
print @sql
exec (@sql)

fetch next from cur_col into @cur_col

END

close cur_col
deallocate cur_col


GO


ASP调用

<!--#include file= "../function/conn.asp "-->

< %bi_id= "20070116103436 "
set objCmd=Server.CreateObject( "Adodb.Command ")
objCmd.ActiveConnection=conn
objCmd.CommandText= "pro_feibiao " '指定存储过程名称
objCmd.CommandType=4 '其为Stored Procedure
objCmd.Prepared = true
objCmd.Parameters.append objCmd.CreateParameter( "bi_id ",200,1,50,bi_id)
objCmd.Execute
response.Write " <script> alert( '测试！ ');location= 'xjkj_list.asp '; </script> "
response.End()
% >
我的目的是传递bi_id参数，执行存储？
我的有错误请指点下。。

[解决办法]
set no count on

存储过程第一行加上.