|
Posted on
2009-02-26 18:00
AmyQiu
阅读( 177)
评论()
编辑
收藏
举报
Code
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
|