sql - 如何在存储过程之间共享数据

Question

很难说出这里问的是什么。这个问题是含糊的、模糊的、不完整的、过于宽泛的或修辞性的，无法以目前的形式得到合理的回答。如需帮助澄清此问题以便重新打开它， visit the help center 。

已关闭 10 年前。

存在许多与在 MS SqlServer 中的另一个存储过程中共享一个存储过程的数据结果相关的问题。

根据 SQL Server 的版本，人们建议使用临时表、xml (SQLServer 2005) 或表变量 (SQL Server 2008)。

Erland Sommarskog 写了一篇很棒的文章它提供了全面的答案并列出了不同版本的 SQL 中可用的所有选项:

• How to Share Data Between Stored Procedures

我认为值得分享。

我在 reading an answer by deevus 时看到了那篇文章建议使用INSERT-EXEC Statement ，一些我以前不太熟悉的东西

Answer 1

Erland Sommarskog 写了一篇很棒的文章它提供了全面的答案并列出了不同版本的 SQL 中可用的所有选项:

• How to Share Data Between Stored Procedures

This article tackles two related questions:

• How can I use the result set from one stored procedure in another, also expressed as How can I use the result set from a stored procedure in a SELECT statement?
• How can I pass a table as a parameter from one stored procedure to another?

In this article I will discuss a number of methods, and also point out their advantages and drawbacks. Some of the methods apply only when you want to reuse a result set, whereas others apply in both situations. In the case you want to reuse a result set, most methods require you to rewrite the stored procedure in one way or another, but there are some methods that do not.