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.


more ▼

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

avatar image

302 17 19 22

(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

avatar image

26.2k 18 37 48

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Feb 09, 2011 at 08:41 PM

Seen: 757 times

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

Copyright 2018 Redgate Software. Privacy Policy