Wednesday, May 16, 2012

T-SQL: Select node value from xml column

SQL Code:

Column name is wau_xml

SELECT wau_xml.value('(/Document/VersionNo)[1]', 'int') FROM Table


XML in column:

<Document>

<VersionNo>1</VersionNo>

</Document>


13 comments:

  1. All life demands struggle. Those who have everything given to them become lazy, selfish, and insensitive to the real values of life. The very striving and hard work that we so constantly try to avoid is the major building block in the person we are today. See the link below for more info.

    values @
    www.inspgift.com

    ReplyDelete
  2. Hi there, just wanted to tell you, I enjoyed browsing here in your blog site it has lots of good stuff to read about.

    www.joeydavila.net

    ReplyDelete
  3. Love it! Very interesting topics, I hope the incoming comments and suggestion are equally positive. Thank you for sharing this information that is actually helpful.


    matreyastudios
    matreyastudios.com

    ReplyDelete
  4. This is an article well worth learning, there is much to learn from, each of us should write more articles to their own information available to everyone to know that we can learn from each other, with the progress.

    Jenna
    www.imarksweb.org

    ReplyDelete
  5. Hello, I read your blogs on a regular basis. Your humoristic style is awesome, keep it up!

    Fake Oakleys

    ReplyDelete
  6. We all need challenges in our life to keep motivated. I really had a great time scanning and reading your blog site and i was so amazed with your great artwork. I do hope you could inspire more readers. You can also visit my site for some interesting stuff.

    n8fan.net

    www.n8fan.net

    ReplyDelete
  7. Thanks for sharing your article and for giving us the chance to read it. It is very helpful and encouraging. Visit my site too.

    triciajoy.com

    www.triciajoy.com

    ReplyDelete