存储过程的参数问题？

[hopewj]

原存储过程：(sql 2000 中）
CREATE PROCEDURE [dbo].[nihao] @qq int AS
insert into table1(id)
(select id from kc_main where id=@qq)
GO
pb中的调用：
declare nh procedure for
nihao
@qq=28158
using sqlca;
execute nh;
这个参数是这样写吗，不用参数还有结果，用了参数就不行，各位给看看！

[lmby]

declare nh procedure for
nihao
@qq=28158
using sqlca;
execute nh;

commit;

[liliang800207]

up

[qqjj7758]

哦

[heimang]

declare nh procedure for
nihao
@qq=28158;
execute nh ;
试试吧，声明存储过程时，最后一个变量后要有分号的

[heijiangff]

oracle还行

[qianduo]

declare nh procedure for nihao
@qq=28158;

using sqlca;
execute nh;
close nh;

[xinsmith]

declare nh procedure for
nihao
@qq=28158;
execute nh ;
close nh;