title: SQL server stored procedure return a table
body: <p>I have a stored procedure that takes in two parameters. I can execute it successfully in Server Management Studio. It shows me the results which are as I expect. However it also returns a Return Value.</p>
  
  <p>It has added this line,</p>
  
  <pre><code> SELECT 'Return Value' = @return_value
  </code></pre>
  
  <p>I would like the stored procedure to return the table it shows me in the results not the return value as I am calling this stored procedure from MATLAB and all it returns is true or false.</p>
  
  <p>Do I need to specify in my stored procedure what it should return? If so how do I specify a table of 4 columns (varchar(10), float, float, float)?</p>