dbTalk Databases Forums  

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

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


Discuss SOAP endpoint: Doesn't publish user defined table functions - why? in the microsoft.public.sqlserver.connect forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
Axel Dahmen
 
Posts: n/a

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






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


Reply With Quote
  #32  
Old   
Axel Dahmen
 
Posts: n/a

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






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


Reply With Quote
  #33  
Old   
Axel Dahmen
 
Posts: n/a

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



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


Reply With Quote
  #34  
Old   
Axel Dahmen
 
Posts: n/a

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



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


Reply With Quote
  #35  
Old   
Axel Dahmen
 
Posts: n/a

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



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


Reply With Quote
  #36  
Old   
Axel Dahmen
 
Posts: n/a

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



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


Reply With Quote
  #37  
Old   
Axel Dahmen
 
Posts: n/a

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



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


Reply With Quote
  #38  
Old   
Peter Yang[MSFT]
 
Posts: n/a

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



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.


Reply With Quote
  #39  
Old   
Peter Yang[MSFT]
 
Posts: n/a

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



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.


Reply With Quote
  #40  
Old   
Peter Yang[MSFT]
 
Posts: n/a

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



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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.