再问一个如何使用存储过程的返回值！急！

[hzcao]

create proc a
as
declare @price as numeric(18,2)
set @price=4
return @price
go

create proc b
as
declare @price as numeric(18,2)
...

@price=(exec a)
go

[hzcao]

错了
create proc b
as
declare @price as numeric(18,2)
...

set @price=(exec a)
go

以上这样好像不可以，请问我如何可以使用存储过程的返回值？

[axiaowin]

设定返回参数
create proc a
@price numeric(18,2) output
as
set @price=4
select @price
go

declare @priceout numeric(18,2)
exec a @priceout output

[pengdali]

create proc a
as
declare @price as numeric(18,2)
set @price=4
return @price
go

create proc b
as
declare @price as numeric(18,2)
...

exec @price=a
go

[axiaowin]

create proc a
@price numeric(18,2) output
as
set @price=4
select @price
go

declare @priceout numeric(18,2)
exec a @priceout output
select @priceout

[cloudchen]

create porc b
@a int output
as
select @a=id from tableName where username = 'xx'
go

declare @i int
exec b @a=@i output
select @i

[zjcxc]

create proc a
as
declare @price as numeric(18,2)
set @price=4
return @price
go

create proc b
as
declare @price as numeric(18,2)
...

exec @price=a --这样就可以了.
select 返回结果=@price
go