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>


Posted by kevo at 5:23 PM
Labels: ,

12 comments:

  1. AnonymousSeptember 23, 2013 at 8:33 AM

    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. UnknownMarch 26, 2014 at 1:57 AM

    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. UnknownOctober 11, 2014 at 2:27 AM

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

    Fake Oakleys

    ReplyDelete
  4. joyJanuary 13, 2015 at 3:36 AM

    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
  5. UnknownMarch 5, 2016 at 2:53 AM

    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
  6. UnknownMarch 16, 2016 at 6:16 AM

    This comment has been removed by the author.

    ReplyDelete
  7. UnknownMarch 16, 2016 at 6:16 AM

    This comment has been removed by the author.

    ReplyDelete
  8. UnknownMarch 16, 2016 at 6:17 AM

    This comment has been removed by the author.

    ReplyDelete
  9. UnknownMarch 16, 2016 at 6:17 AM

    This comment has been removed by the author.

    ReplyDelete
  10. UnknownMarch 16, 2016 at 6:18 AM

    This comment has been removed by the author.

    ReplyDelete
  11. UnknownJune 1, 2016 at 4:34 AM

    Your blog is fabulous.

    www.gofastek.com

    ReplyDelete
  12. UnknownDecember 6, 2018 at 4:52 PM


    شركة نقل عفش من الدمام الى الرياض شركة نقل عفش من الدمام الى الرياض
    ارخص شركة نقل عفش بمكة شركة نقل عفش بمكة
    شركة نقل عفش من جدة الى الاردن شركة نقل عفش من جدة الى الاردن
    شركة نقل عفش من الرياض الى مصر شركة نقل عفش من الرياض الى مصر
    شركة نقل عفش بالدمام شركة نقل عفش بالدمام
    شركة نقل عفش بالاحساء شركة نقل عفش بالاحساء
    نقل عفش داخل مكة نقل عفش داخل مكة


    ReplyDelete

Subscribe to: Post Comments (Atom)