Post reply

xml dom in t-sql

  • June 22, 2005 at 2:49 pm

    #167513

    I have a parameter that holds an xml string and I want to get one of his nodes (same like the getChild() method )

    I want to do it on t-sql and to get the string back as a formatd xml string any Idea how can I do it

    Thanks!!! and sorry for my bad English

  • June 22, 2005 at 2:50 pm

    #567698

    Why not do it all client side?

  • June 22, 2005 at 3:10 pm

    #567709

    I'm using the xml to create a dynamic filter and I just want to take one of the nodes off before creating the where part of my dynamic query.

     

  • June 22, 2005 at 3:10 pm

    #567708

    I'm using the xml to create a dynamic filter and I just want to take one of the nodes off before creating the where part of my dynamic query.

     

  • June 24, 2005 at 8:25 am

    #568284

    I've just recently used sp_xml_preparedocument for the first time to do this kind of thing, so maybe I'm off base. After the sp_xml proc the XML looks like a table - can't you delete the row corresponding to the node you want to drop, or better yet, can't the criteria you're using to decide to drop that node be combined with the JOIN or WHERE you're using the XML in to get the same effect?

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

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