Post reply

delete only the root in xml

  • April 15, 2008 at 1:40 am

    #379806

    Hi all,

    DECLARE @x XML

    SET @x = ' '

    SET @x.modify('delete /root')

    SELECT @x

    From this example, i want to delete only the root.

    means i except the result like this.

    any idea?

  • April 15, 2008 at 2:01 am

    #802394

    Can't see your example, but this works...

    DECLARE @x XML

    SET @x = '<root><a><b /></a><c d="e" /></root>'

    SET @x = @x.query('root/*')

    SELECT @x

    /* Results

    <a><b /></a><c d="e" />

    */

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.

  • April 15, 2008 at 3:32 am

    #802417

    Hi Ryan Randall,

    WOW .... Great Man. Thank you very much ... 🙂

  • April 15, 2008 at 3:35 am

    #802420

    Nice feedback - thank you 🙂

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.

Viewing 4 posts - 1 through 3 (of 3 total)

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