【转】带返回记录条数的存储过程

方法一:

CREATE PROCEDURE [dbo].[bmzh_test]
@shb1 Datetime,
@shb2 datetime,
@aa int output
AS
select @aa=Count(*) from [ychxtbak].[dbo].[bmzh] where shb>@shb1 and shb<=@shb2
return @aa
GO  

方法二:利用系统变量@@ROWCOUNT来取得记录条数

CREATE PROCEDURE [dbo].[bmzh_select]
@shb1 Datetime,
@shb2 Datetime,
@rowcount int output
AS
select * from [ychxt].[dbo].[bmzh] where shb>@shb1 and shb<=@shb2
set @rowcount=@@rowcount
GO

--调用示例
declare @aa int
exec bmzh_select 1,2,@aa output
print '响应记录数:'+cast(@aa varchar)