declare @Sql nvarchar(1000)
    
    set @Sql = 'select top ('+CONVERT(varchar(50),@pageSize)+') * from '+@tableName+' where '+@ID+' not in(select top(('+CONVERT(varchar(50),@pageIndex)+'-1)*'+CONVERT(varchar(50),@pageSize)+') '+@ID+' from '+@tableName+'  where RecEmail='+@RecEmail+')  and RecEmail='+@RecEmail+'';
    set @Sql += 'select @row=COUNT(1) from '+@tableName+'  where RecEmail='+@RecEmail+'';
    
    --系统存储过程
    exec sp_executesql @Sql,N'@row int out',@rowCount out    
    
END
GO

declare @rowCount int
exec Email_Pager 'Email','ID','songxinlei@1505.com',5,2,@rowCount out
select @rowCount