开发者

How to get the stored procedure result set value

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 o开发者_如何学Cther part of the proc A.


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;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜