Tags » XQuery

Xquery, How to add an attribute to an XML element with out using a function

Here’s the starting XML:

<sec sec-type="bodytext">
  <title>Largest Cities (Population)</title>
  <list list-type="bullet">
    <list-item>
      <p> Billings (103,994)</p>
    </list-item>
    <list-item>
      <p> Missoula (57,053)</p>
    </list-item>
  </list>
</sec>

I want to add this attribute list-content=”largest_cities” to element “list”. 128 more words

Recent Questions - Stack Overflow

Reading Bulk XML From File using SSMS

Large data mostly involvs Xml Contents. One can query Xml content in SQL Server management studio (SSMS)  when he xml is small.  Imagine there is a very large XML file , opening the xml file for edit and pasting the content of the xml file in  SSMS new query window is tedious and cumbersome. 1,176 more words

Beginner

How To : Parse sibling repeating groups without wrapper element

Long time no post, so here’s a new (short) article.
Behind the cryptic title lies a situation like this :

<root>
  <id>1</id>
  <name>SMITH</name>
  <id>2</id>
  <name>WILSON</name>
  <id>3</id>
  <name>GRANT</name>
</root>
… 632 more words
HowTo