title: Pagination based on parameters (OFFSET FETCH NEXT)
body: <p>How I display All data when parameters are null,</p>
  
  <pre><code>DECLARE @PageSize INT = 5
          ,@PageNo  INT = 2
  
  SELECT *
  FROM [MyTable]
  ORDER BY [NO]
  OFFSET @PageSize * (@PageNo - 1) ROWS
  FETCH NEXT @PageSize ROWS ONLY
  </code></pre>