![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
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