Tags » XQuery

Manipulating XML in MS-SQL using XQuery - a beginners guide

A link to a blog that can be used as the starting point for those who need to manipulate XML held in MS-SQL.


XPath vs XQuery

XPath vs XQuery XPath and XQuery are similar in some ways. XPath is even an integral part of XQuery. Both languages allow you to select bits of data from an XML document or an XML document store. 335 more words


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">
      <p> Billings (103,994)</p>
      <p> Missoula (57,053)</p>

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


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 :

… 632 more words