title: Get count of records of a table which return from stored procedure
body: <p>I have a stored procedure, which is returning a table. I just want the count of the records is it possible</p>
  
  <p><strong>My Procedure</strong></p>
  
  <pre><code>create procedure Test
  as begin
  select * From Student
  end
  </code></pre>
  
  <p>exec Test
  will give the records out put 
  I want the count</p>
  
  <p>NB: I need the sp to return the results of select statement.In another place I need the count of the records returned by sp and columns in the student table is dynamic.</p>
  
  <p>I am expecting an answer without modifying stored procedure. </p>