use Stored procedure return a tabel(存储过程返回table)

存储过程返回table

CREATE PROCEDURE a

x INT

AS

SELECT * FROM TABLE WHERE XX > x  -- no RETURN

DECLARE @a INT = 1

CREATE @VarTable Table

(

     *

)

INERT @VarTable

EXEC A @a