Mssql stored procedure calls method sharing of results in another stored procedure

Summary:

The following will share how to call "the return result of another stored procedure" in "one stored procedure" and apply it to its own operations

In actual development, we often encounter the return result of calling another stored procedure in one stored procedure (stored procedures apply to each other)

The idea of implementation is to use temporary table to store the result set returned by the stored procedure, and then to apply it to another stored procedure.

As follows:

Create proc pr_b @ an int,@b intasbegin select @ an as a @ b asb union all select @ aqum1 as a @ baked 1 asb endgo- to create a stored procedure pr_a, and call the result returned by the stored procedure pr_b create proc pr_a asbegin create table # t (an int,b int) insert into # t (AME b) exec pr_b 120188 select * from # t truncate table # t drop table # tendgo

This is an article from "Cat House".