Db4Breakfast
Wednesday, July 16, 2014
XQuery: Aggregration With Multiple Levels
›
On the last post, the examples aggregate data with single level (group by customers). Today we'll explore how to aggregate data with mul...
2 comments:
Tuesday, July 15, 2014
XQuery: Aggregation with Join
›
Today we'll learn about aggregation using XQuery FLWOR expressions. Assume that we have a customers and an orders XML document. The exa...
Thursday, July 3, 2014
Outer Join XML Data Using XQuery
›
Today we'll learn about outer join in XQuery. -- -- assume that we have 2 XML documents, customers orders. -- load xml files to SQL S...
Saturday, June 28, 2014
Inner Join XML Data Using XQuery
›
Today we'll learn how to join XML data using XQuery. -- -- assume that we have 2 XML documents, customers and orders. -- load xml fil...
Tuesday, June 24, 2014
Import & Concatenate XML Documents in SQL Server
›
To prepare for next blog post (XML Inner Join using XQuery), today, we'll learn how to import and concatenate XML documents in SQL Serve...
Friday, June 13, 2014
XQuery FLWOR Expression Part II
›
In this post we will learn how to filter and sort data in XQuery when querying XML. -- let's assume that we have a table contain owner...
Tuesday, June 10, 2014
XQuery FLWOR Expression
›
In previous several posts, I provided some examples querying XML data mainly using XPath Expressions. Today we'll learn about the FLWOR...
›
Home
View web version
