I have certain questions on With Result Set for which googling didnot gave me very good answer. Could you please help ?
a) With Result Set can be extended for multiple result set. What is the maximum number of possible extension?
b) What are the limitations of With Result Set option of Execute statement? I found one as the number of columns should be same as that of the resultset.Any thing else?
N.B.~ I wanted to know this answer for myself only.
Seeing as how Denali is still in development and features are not locked in for release yet (as far as has been communicated outside MS), there is little surprise that you couldn't find any information on this.
I would venture a guess that a) is as many as you return, there is no limit to how many result sets you can return to a connection (as far as I know).
To answer b): The returned data must be castable as the result set definition. This means that if you set the result set to return an int and your query returns a character value ('a' instead of 1) then that would cause a problem.
answered Feb 09, 2011 at 11:24 PM