Tag Archives: XQuery

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 5 Comments

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 1 Comment

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | Leave a comment

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 3 Comments

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 11 Comments

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 10 Comments

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 5 Comments

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 8 Comments

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() … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 10 Comments

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, XQuery | Tagged , , , | 8 Comments