存储过程嵌套的问题for example:
-------------------------------------------------------
create procedure sp_test1
@id int output
as
begin
set @id = 100
return
end
gocreate procedure sp_test2
as
begin
declare @id int
exec sp_test1 @id output
select @id
end
goexec sp_test2
godrop procedure sp_test1,sp_test2
go
-------------------------------------------------------
create procedure sp_test1
@id int output
as
begin
set @id = 100
return
end
gocreate procedure sp_test2
as
begin
declare @id int
exec sp_test1 @id output
select @id
end
goexec sp_test2
godrop procedure sp_test1,sp_test2
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货