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 … Continue reading XQuery for the Non-Expert – Substring() Function

XQuery for the Non-Expert – Resources

Learning XQuery can be a pain.  There are a lot of different uses for XML and different languages implement it in many different fashions.  To help clear the air a bit, I wrote a number of posts on XQuery; which this post is a part of. Now that I’ve posted my initial posts on what … Continue reading XQuery for the Non-Expert – Resources

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 … Continue reading XQuery for the Non-Expert – Exist

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 … Continue reading XQuery for the Non-Expert – Value

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 … Continue reading XQuery for the Non-Expert – Query

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 … Continue reading XQuery for the Non-Expert – Nodes

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 … Continue reading XQuery for the Non-Expert – XMLNAMESPACE