title: There was an error parsing the query. [ Token line number = 1,Token line offset = 39,Token in error = ( ]
body: <p>I'm working in WinForms application. My requirement is loading the data from sql on demand(i.e load 100 records for a page, when moves to that page). So i tried below SqlCommand but it throws the exception at place of "ROW_NUMBER()" syntax in the below command,</p>
  
  <pre><code>SELECT * 
  FROM (SELECT *
        , ROW_NUMBER() (ORDER BY [ID]) AS RowNum 
        FROM [tblVGTest] 
        WHERE [ID]) AS Temp 
  WHERE RowNum BETWEEN 0 AND 100
  </code></pre>
  
  <p>Please let me know, is there any mistakes in command or provide any suggestion for my scenario.</p>
  
  <p>Thanks</p>