use Stored procedure return a tabel(存储过程返回table)
时间:2011-03-23 来源:张银虎
存储过程返回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
相关阅读 更多 +