x

Some questions on Denali's WithResultSet

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.

Thanks
more ▼

asked Feb 09, 2011 at 08:41 PM in Default

learner gravatar image

learner
302 17 18 20

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.
more ▼

answered Feb 09, 2011 at 11:24 PM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x13

asked: Feb 09, 2011 at 08:41 PM

Seen: 670 times

Last Updated: Feb 09, 2011 at 08:47 PM