存储过程(根据id 来查找一个表中的值,然后根据这个值,查找另外一个表的值?)

create procedure in_a_b
@value int
@value_out output --传出的值
as
BEGIN
declare @a1 number
declare @b1 number
select @a1=a.a1 from a where a.a2=@value
select @value_out=b.b1 from b where b.b2=@a1
END
GO

创建
CREATE PROCEDURE p(out value int)
begin
declare iii char(50);
select name from a where id=value into iii;
select c from b where name=iii into c;
end

使用：
set @v=9;
call p(@v);
select @v;这时v等于查到的值