How to get the returned data from the SQL Server stored procedure

1. Returns a value

DECLARE @count int exec @count = testreturn \ ' 111\ ', \ ' 222\ ' select @count

@count is the value returned is the INT type

2. Return a data table

Start by creating a new data table
CREATE TABLE Test (
  tmp_order_id   varchar (20)
)
The returned data is then inserted into the table

Get the contents of a table
SELECT * FROM Test
To delete a generated data table
DROP TABLE test;


For more details, refer to: http://blog.csdn.net/liangweiwei130/article/details/6691207

How to get the returned data from the SQL Server stored procedure