Tags » XQuery

MarkLogic buddies up to JavaScript, throws shade at old pal XML

Database company MarkLogic has extended its NoSQL data store to work natively with JavaScript and the popular JSON data exchange format, in addition to the XML format it has long supported. 600 more words


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


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

When will restricted materials become available?

One morning recently, our records services archivist sent me an email. He was wondering if there was a way I could report to him on which materials in our university archives have restrictions that have passed. 335 more words

Legacy Data

Manipulating SQL SERVER database table's data with XML XPath and XQuery


Sometimes we need sql server tables’s data(tables with Primary-Foreign key relationship) as a XML type to workout some of our need.

With the introduction of the XML datatype in SQL SERVER 2005, it provides the flexibility to generate xml type from the data contained inside sql server tables. 229 more words