title: Syntax error near 0
body: <p>What's wrong with the following statement? I'm using SQL Server 2008.</p>
  
  <pre><code>use Demo;
  
  SELECT * FROM users
  limit 0 , 30
  </code></pre>
  
  <p>I got: </p>
  
  <pre><code>Msg 102, Level 15, State 1, Line 4
  Incorrect syntax near '0'.
  </code></pre>
  
  <p>That's really weird. I tried Google but didn't find much info.</p>