title: Counting results of stored procedure
body: <p>I have a stored procedure returning ID, Name, Descriptions and takes no input parameters. However, I am interested in how many results do I get.</p>
  
  <p>I expected something like this work:</p>
  
  <pre><code>SELECT COUNT(*) FROM EXEC MyStoredProcedure
  </code></pre>
  
  <p>But I get the following error in SqlServer Managment Studio: 
  Incorrect syntax near the keyword 'EXEC'. 
  Could you show me a little code example how can I do that?</p>