SQL server stored procedure return a table

Question

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.

It has added this line,

 SELECT 'Return Value' = @return_value 

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.

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)?

Answer 1

A procedure can't return a table as such. However you can select from a table in a procedure and direct it into a table (or table variable) like this:

create procedure p_x as begin declare @t table(col1 varchar(10), col2 float, col3 float, col4 float) insert @t values('a', 1,1,1) insert @t values('b', 2,2,2)  select * from @t end go  declare @t table(col1 varchar(10), col2 float, col3 float, col4 float) insert @t exec p_x  select * from @t