用例子說明﹕
CREATE PROCEDURE dbo.SQ1 AS
begin
select top 10 OrderID, ProductID From [Order Details]
end
GO
//===============================
CREATE PROCEDURE dbo.SQ2 AS
begin
CREATE Table #SSS (OrderID int,ProductID int)
INSERT INTO #SSS EXEC dbo.SQ1
SELECT * From #SSS
DELETE #SSS
end
GO
在上而的例子中﹐在SQ2中調用SQ1查詢返回的結果