sp output

 

Create proc sp_c_select
 @CustomerID int,
 @RowCount int output
as
select @RowCount=Count(*) from c 
where customerid=@CustomerID

------------------------------------------------------------
declare @Result int
exec sp_c_select @CustomerID=1, @RowCount=@Result output
--或exec sp_c_select 1, @Result output
select @Result