title: SQL Server Query SELECT Error (now trying LIMIT)
body: <p>I am working on what should be a super simple query for SQL Server 2014. All I want to do is check that our systems can interface with SQL Server after updates, etc. So I need to just verify that it makes the connection correctly and finds a table within the Server.</p>
  
  <p>Attempt 1:</p>
  
  <pre><code>SELECT TOP (1) *
  From [X].[dbo].[Y]
  WITH (NOLOCK);
  </code></pre>
  
  <p>But apparently 'top' is not a supported option with SQL Server 2014.
  To add some more, here is the exact error I get when trying to run that: Syntax error. The token 'Top' is invalid. Please check the case of your operators (eg 'or' versus 'OR') and check that your functions use brackets after the function name eg Now(), eg Len("abc").</p>
  
  <p>Attempt 2:</p>
  
  <pre><code>SELECT *
  From [X].[dbo].[Y]
  WITH (NOLOCK)
  LIMIT (1);
  </code></pre>
  
  <p>That one tells me that I need to put data items between [], text between "", and functions as FunctionName(). However...I don't see where I missed any of those.</p>
  
  <p>Can anybody possibly shed some light on why my query isn't going through? Any help would be appreciated.</p>