Tag Archive for XQuery

Talk To The Experts

XQuery for the Non-Expert – Aggregates

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In  the last post, I discussed using functions within XQuery with the Substring() function as part of the XQuery for the Non-Expert blog series.  To continue on that theme, this post is going to take a look into…

Talk To The Experts

XQuery for the Non-Expert – @Variable Use

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert blog series.  When working with the exist() method you may not always want to hardcode in the attribute values that you…

Talk To The Experts

XQuery for the Non-Expert – Binary Values

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the value() method post of my XQuery for the Non-Expert series I discussed how to take element and attributes and return them as column values.  Those methods works all fine and dandy for most data but when…

Talk To The Experts

XQuery for the Non-Expert – Substring() Function

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. Within the value() and query() methods it is sometimes desirable to return a portion of a string.  Similar to T-SQL, there is a substring function in XQuery that provides this functionality. In this XQuery for the Non-Expert post…

Talk To The Experts

XQuery for the Non-Expert – Exist

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the previous post, I discussed the value() method as part of my XQuery for the Non-Expert series.  This next post will deal with a topic similar to the exist() method – the determination of whether a element…

Talk To The Experts

XQuery for the Non-Expert – Value

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed the query() method in my XQuery for the Non-Expert series.  With this next post, we’ll be working on taking data out of the XML fragments and placing them into columns with the…

Talk To The Experts

XQuery for the Non-Expert – Query

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed the nodes() method in my XQuery for the Non-Expert series.  With this next post, we’ll be looking into the query() method. The main use for the query() method is to retrieve child…

Talk To The Experts

XQuery for the Non-Expert – Nodes

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed XMLNAMESPACES in the XQuery for the Non-Expert series.  With this post, we’ll be looking into the nodes() method. Where XMLNAMESPACES is the map through the XML document, the nodes() method is the…

Talk To The Experts

XQuery for the Non-Expert – XMLNAMESPACE

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. Let’s talk about XMLNAMESPACE.  Are you excited?  Does your skin crawl with excitement – or rather unease at the thought of leveraging this T-SQL clause? The goal here is to make XQuery and it’s functions and clauses easier…