How to get the stored procedure result set value

2019-07-15 22:24发布

I create a stored proc A that calls another proc B, which returns a list of the result set.

How I can use these result set values in my proc A as I have to use this result set value one by one to pass to other part of the proc A.

1条回答
看我几分像从前
2楼-- · 2019-07-15 23:28

You can perform an INSERT INTO to insert the results of the stored procedure into a (temporary) table. You can then use a select statement to process these results.

INSERT INTO SomeTableThatMatchesTheSproc
EXEC YourStoredProcedure;

SELECT * FROM YourTable;
查看更多
登录 后发表回答