请问存储过程的返回值在另一个存储过程中怎么取?
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,语法怎么写?