~~鱼跃~~

I Want to fly!

导航

如何在存储过程内调用带参数的存储过程

Posted on 2006-04-24 23:52  flyfish  阅读(380)  评论(0编辑  收藏  举报
create   procedure   p1
@parm1   varchar(20)   output
as
set   @parm1='AAAAAA'

go

create   procedure   p2
as
declare   @tmp   varchar(20)
exec   p1   @tmp   output
select   @tmp
go

--测试
exec   p2