Is it true Tabled Value-function can not be used as WEBMETHOD such Scalar Valued-function?

Question

Post reply

Is it true Tabled Value-function can not be used as WEBMETHOD such Scalar Valued-function?

eko indriyawan

Hall of Fame

Points: 3316
More actions
September 18, 2009 at 4:46 pm

#209956

Upon successful completion of one problem, is now faced
with new problems more complex and challenging.
This problem is related to the WebService, so here I have
created obstacles in WEBMETHOD endpoint. These barriers is
to create a Table-Valued Functions into WEBMETHOD.
As information for you, if I make the scalar-function Valued
as WEBMETHOD, then all can work properly. However, why this
does not work when the Table-Valued function I made as WEBMETHOD?
Was member in this forum can help me solve this problem?
King Regards,
Eko Indriyawan

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 1

Is this question so difficult? For several days no one answered

Lowell SSC Guru Points: 323518 More actions · Answer 2

SQL Server's SOAP does not support table valued functions unfortunately. This is why it's not working. I found this out by talking to one of the testers. I cannot find where this is mentioned in the docs yet.

see this ms link:

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/fd59daeb-cbc2-4327-8499-f693b4567140

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 3

Hello Lowell,

Although I am sad to read the news,

but I'm happy you've helped me in getting this information.

King regards,

Eko Indriyawan

Matt Whitfield SSCrazy Eights Points: 8107 More actions · Answer 4

eko - you may also want to consider, if you're at an appropriate stage in the project, whether you want to use the SOAP endpoint because the feature is deprecated (i.e. will be dropped in a future version of SQL Server).

Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 5

Matt Whitfield (9/22/2009)
eko - you may also want to consider, if you're at an appropriate stage in the project, whether you want to use the SOAP endpoint because the feature is deprecated (i.e. will be dropped in a future version of SQL Server).

Hello Matt,

I do not know if Microsoft will be delete this feature later.

Please give me your articles or news related to issue,

I really needed it. Because I use endpoint to generate

WSDL in the project that I created.

regards,

Eko Indriyawan

Matt Whitfield SSCrazy Eights Points: 8107 More actions · Answer 6

http://msdn.microsoft.com/en-us/library/cc280436.aspx

Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Matt, Thank you for the link. I was not aware of this either and have been looking at it for a couple of projects that are currently on the back burner.

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 8

Matt Whitfield (9/22/2009)
http://msdn.microsoft.com/en-us/library/cc280436.aspx

Hello matt,

Thank you very much,

I think I'm still using MSSQLServer2008. If later on will be eliminated

in the latest version I also do not need to worry, because the migration

from the endpoint to. NET is not a big problem. But right now I still feel

comfortable with Endpoint more efficient and practical in the development

king regards,

Eko Indriyawan

Matt Whitfield SSCrazy Eights Points: 8107 More actions · Answer 9

Lynn / eko

No probs - glad to be useful! 🙂

Edit -> sorry eko - just one more thing - make sure you read the bit about 'types implemented after 2005' and make sure they don't apply to you. I.e. if you plan on using any of the 2008+ data types, be careful.

Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 10

Matt Whitfield (9/22/2009)
Lynn / eko
No probs - glad to be useful! 🙂
Edit -> sorry eko - just one more thing - make sure you read the bit about 'types implemented after 2005' and make sure they don't apply to you. I.e. if you plan on using any of the 2008+ data types, be careful.

Hello matt,

Thanks for your advice.

So far, I still can work properly using MSSQL Server 2008

regards,

Eko Indriyawan