Post reply

Accessing Child node from xml data type

  • March 9, 2011 at 5:59 am

    #248023

    Hi, How can i access a child node using a select query from sql server..

    🙂

  • March 9, 2011 at 9:24 am

    #1296595

    DECLARE @x XML = N'<parent><child>Hello World!</child></parent>' ;

    SELECT @x.query('/parent/child') ;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

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