SOAP endpoint: Doesn't publish user defined table functions - why?

#31

Hi Peter,

I just made up some thoughts:

Quote:

Youo can create a regular stored procedure and in it return a select
statement. This works fine with SOAP as-is.

A Stored Procedure might not be sufficient as it doesn't provide a type-safe way of returning tabular data. I would have guessed that a TF UDF would have returned a typed dataset or an array of structs or anything type-safe.

Your thoughts on this?

TIA,
Axel Dahmen

#32

Hi Peter,

I just made up some thoughts:

Quote:

Youo can create a regular stored procedure and in it return a select
statement. This works fine with SOAP as-is.

A Stored Procedure might not be sufficient as it doesn't provide a type-safe way of returning tabular data. I would have guessed that a TF UDF would have returned a typed dataset or an array of structs or anything type-safe.

Your thoughts on this?

TIA,
Axel Dahmen

#33

Hi Peter,

I just made up some thoughts:

Quote:

Youo can create a regular stored procedure and in it return a select
statement. This works fine with SOAP as-is.

A Stored Procedure might not be sufficient as it doesn't provide a type-safe way of returning tabular data. I would have guessed that a TF UDF would have returned a typed dataset or an array of structs or anything type-safe.

Your thoughts on this?

TIA,
Axel Dahmen

#34

Hi Peter,

I just made up some thoughts:

Quote:

Youo can create a regular stored procedure and in it return a select
statement. This works fine with SOAP as-is.

A Stored Procedure might not be sufficient as it doesn't provide a type-safe way of returning tabular data. I would have guessed that a TF UDF would have returned a typed dataset or an array of structs or anything type-safe.

Your thoughts on this?

TIA,
Axel Dahmen

#35

Hi Peter,

I just made up some thoughts:

Quote:

Youo can create a regular stored procedure and in it return a select
statement. This works fine with SOAP as-is.

A Stored Procedure might not be sufficient as it doesn't provide a type-safe way of returning tabular data. I would have guessed that a TF UDF would have returned a typed dataset or an array of structs or anything type-safe.

Your thoughts on this?

TIA,
Axel Dahmen

#36

Hi Peter,

I just made up some thoughts:

Quote:

Youo can create a regular stored procedure and in it return a select
statement. This works fine with SOAP as-is.

A Stored Procedure might not be sufficient as it doesn't provide a type-safe way of returning tabular data. I would have guessed that a TF UDF would have returned a typed dataset or an array of structs or anything type-safe.

Your thoughts on this?

TIA,
Axel Dahmen

#37

Hi Peter,

I just made up some thoughts:

Quote:

Youo can create a regular stored procedure and in it return a select
statement. This works fine with SOAP as-is.

A Stored Procedure might not be sufficient as it doesn't provide a type-safe way of returning tabular data. I would have guessed that a TF UDF would have returned a typed dataset or an array of structs or anything type-safe.

Your thoughts on this?

TIA,
Axel Dahmen

#38

Hello Axel,

yes I agree that a type-safe dataset might be an better option in such kind
of situation. However, I think there might be other side-effect and
complexsity when implementing this. Also, I think this limiation should be
better document

Please rest assured that I will forward your feedback on this feature and
document.

In additioin, I encourage you submit your feedback on product via the link
below so that our product team could hear your voice directly:

http://lab.msdn.microsoft.com/produc...k/default.aspx

If you have further comments or concerns, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

#39

Hello Axel,

yes I agree that a type-safe dataset might be an better option in such kind
of situation. However, I think there might be other side-effect and
complexsity when implementing this. Also, I think this limiation should be
better document

Please rest assured that I will forward your feedback on this feature and
document.

In additioin, I encourage you submit your feedback on product via the link
below so that our product team could hear your voice directly:

http://lab.msdn.microsoft.com/produc...k/default.aspx

If you have further comments or concerns, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

#40

Hello Axel,

yes I agree that a type-safe dataset might be an better option in such kind
of situation. However, I think there might be other side-effect and
complexsity when implementing this. Also, I think this limiation should be
better document

Please rest assured that I will forward your feedback on this feature and
document.

In additioin, I encourage you submit your feedback on product via the link
below so that our product team could hear your voice directly:

http://lab.msdn.microsoft.com/produc...k/default.aspx

If you have further comments or concerns, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SOAP endpoint: Doesn't publish user defined table functions - why?

microsoft.public.sqlserver.connect microsoft.public.sqlserver.connect

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 02:57 AM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 02:57 AM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 02:57 AM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 02:57 AM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 02:57 AM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 02:57 AM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 02:57 AM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 11:57 PM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 11:57 PM

Re: SOAP endpoint: Doesn't publish user defined table functions - why? - 04-29-2008 , 11:57 PM