Value of() in SQL Server?

220 pts.
Tags:
Oracle Statements
SQL
SQL Server
SQL Server 2005
what is the equivalent statement of valueof() of oracle in sql server?

Software/Hardware used:
Sql Server 2005
ASKED: December 16, 2010  12:22 PM
UPDATED: December 16, 2010  10:04 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Are you referring to the DBMS_XSLPROCESSOR Oracle's package ? If so, I think you should explain what you need to achieve without assuming that the SQL Server experts who know how to process XML documents in SQL Server also know how to do it in Oracle and know the ValueOf procedure/function.
    65,110 pointsBadges:
    report
  • Denny Cherry
    What does this function do? Is it a native function? I couldn't find anything called valueof() via Google.
    65,490 pointsBadges:
    report
  • carlosdl
    Hi Denny. There is an Oracle Package named DBMS_XSLPROCESSOR, which "provides an interface to manage the contents and structure of XML documents". The VALUEOF Function and Procedure "retrieves the value of the first node from the tree that matches the given pattern". There is no other ValueOf function or procedure in Oracle, but I'm not sure if that is what the OP meant. It could be a totally different thing. In Java, for example, it is a type conversion method.
    65,110 pointsBadges:
    report
  • Prcvjr
    [...] 2. Carlosdl and mrdenny figure out what the value of () is in SQL server. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following