如题!!
------解决方案--------------------
create procedure sp_test1
@count int output
as
begin
select @count=count(*) from syscolumns
end
go
create procedure sp_test2
as
begin
declare @num int
exec sp_test1 @num output
select @num
end
go
exec sp_test2
go
drop procedure sp_test1,sp_test2
go