title: Sql Server TOP - used?
body: <p>Is there a keyword or metainformation in SQL Server that'll tell you if TOP took effect?</p>
  
  <pre><code>EX:
  Select TOP 5 * From Stuff
  
  RESULT: 5 rows
  </code></pre>
  
  <p>What is the best way to determine if there would have been 6 or more?</p>
  
  <pre><code>I could do:
  SELECT TOP 6 count(*) FROM Stuff
  </code></pre>
  
  <p>But I am concerned about a separate call to retrieve the count because there actual query is much more complicated than this one and on a large table.</p>
  
  <p>Thanks!</p>