"Stored procedure" uses SQL statements to obtain a table returned by a stored procedure

Define a stored procedure as follows:

CREATE proc [dbo]. [Test1] @id Intasselect 1 as ID, ' ABC ' as name union ALL select @id as ID, ' zzz ' as name

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 (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 in a table variable select *from @table    --View results in table variables

It would be a lot of trouble if you wrote that.

There is currently no method like the temp table

SELECT * FROM (EXEC test1 1) as Temp

Let's find out later.

"Stored procedure" uses SQL statements to obtain a table returned by a stored procedure