1、增加声明 @rowTotal int output
2、实现下面方法
declare @strRowSQL nvarchar(4000)
if @strWhere != ''
set @strRowSQL = 'select @RowTotal=count(*) from ['
+ @tblName + '] where ' + @strWhere
else
set @strRowSQL = 'select @RowTotal=count(*) from ['
+ @tblName + '] '
EXEC sp_executesql @strRowSQL,N'@RowTotal INT OUT',@RowTotal OUT