Get a table returned by a stored procedure with an SQL statement

Define a stored procedure as follows:

Create proc [dbo].[test1]@id int asSelect 1  asId'ABC'  asNameUnion  All Select @id  asId'zzz'  asName

Returns two rows of data.
Now you want to call the stored procedure with the SQL statement and put the table he returned into the variable. You can do the following:

 declare   @table  table  (id int , name varchar  ( Span style= "color: #800000; Font-weight:bold; " >50 ) --  Define table variables to hold the contents returned by the stored procedure  insert  into   @table  exec  test1 2  --   Put the results of the stored procedure execution into a table variable  select  *  from   @table  --  View results in table variables  

Get a table returned by a stored procedure with an SQL statement