存储过程返回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
转载于:https://www.cnblogs.com/hu88oo/archive/2011/03/23/1992512.html