请问存储过程的返回值在另一个存储过程中怎么取？

[ffjing]

Such As:

CREATE PROCEDURE dbo.GetID
@name varchar(50)
AS
declare @c int
declare @IID numeric(18)
select @c=(select count(*) from tsys_id where name=@name)
if @c=0
insert into tsys_id(name,id) values(@name,1)
else
update tsys_id set id=id+1 where name=@name

select @IID=(select ID from tsys_id where name=@name)
RETURN @IID

我在另一个存储过程中调用这个存储过程，并且定义了一个变量，怎么把调用这个存储过程的返回值赋给这个变量？
CREATE PROCEDURE dbo.CreateT
AS
declare @Tid numeric (18)
exec GetID @name="Task" --这个的返回值怎么赋给@Tid，语法怎么写？

[txlicenhe]

CREATE PROCEDURE dbo.CreateT
AS
declare @Tid numeric (18)
exec @Tid = GetID @name='Task'

[yujohny]

CREATE PROCEDURE dbo.CreateT
AS
declare @Tid numeric (18)
exec @Tid=GetID 'Task'

[sdhdy]

CREATE PROCEDURE dbo.CreateT
AS
declare @Tid numeric (18)
exec @Tid =GetID 'Task'

[pengdali]

CREATE PROCEDURE dbo.CreateT
AS
declare @Tid numeric (18)
exec @Tid=GetID 'Task'