title: "Incorrect syntax near 'OFFSET'" modift sql comm 2012 to 2008
body: <p>I'm listing questions with this</p>
  
  <pre><code>SELECT q.qTitle, q.qDescription, q.qCreatedOn, u.uCode, u.uFullname, qcat.qcatTitle, q.qId, q.qStatus 
  FROM tblQuestion AS q INNER JOIN tblUser AS u 
  ON q.uId = u.uId INNER JOIN tblQuestionCategory AS qcat 
  ON q.qcatId = qcat.qcatId 
  WHERE (q.qStatus = 1) 
  ORDER BY q.qCreatedOn DESC 
  OFFSET @page*10 ROWS FETCH NEXT 10 ROWS ONLY
  </code></pre>
  
  <p>But there is a problem in my server, </p>
  
  <pre><code>Incorrect syntax near 'OFFSET'.
  Invalid usage of the option NEXT in the FETCH statement.
  </code></pre>
  
  <p>How can I modify my query for sql server 2008?</p>
  
  <p>One more question. How can I write a stored procedure for listing pages? Here is my full of code <a href="http://codepaste.net/gq5n6c" rel="noreferrer">http://codepaste.net/gq5n6c</a></p>
  
  <p>Answer: <a href="http://codepaste.net/jjrkqr" rel="noreferrer">http://codepaste.net/jjrkqr</a></p>