存储过程返回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
存储过程返回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