I have a stored proc that return multiple result sets, and it works perfectly fine. However, I'm writing unit tests for this proc, and so I need to call this from another stored proc. I've handled these multiple result sets in my code by using SqlDataReader.NextResult(). Is there something on these lines in SQL Server that would allow me to do the same from within the calling stored proc? Even before I iterate through the result-sets, there should be a way to store them as well.
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
