at 2:56 PM, Jason Tesser
> wrote:
> > OK so in my case I have a Person, Email, Phone and Address table. I want
> to
> > return the Person and an Array of the others. so my return type would be
> > something like Person, Email[], Phone[], Address[]
> >
> >
that
as oppessed to 1. defining a type for a function to return or 2. a function
that returns 4 out parameters (Person, Address[] ,)
Thanks
On Fri, Sep 11, 2009 at 1:37 PM, Merlin Moncure wrote:
> On Fri, Sep 11, 2009 at 11:46 AM, Jason Tesser
> wrote:
> > Is it faster to use a
Is it faster to use a Stored Proc that returns a Type or has Out Parameters
then a View? Views are easier to maintain I feel. I remember testing this
around 8.0 days and the view seemed slower with a lot of data.