Browse by Tags

• bill of materials
• bulk load
• development
• FLWOR
• function
• introduction
• methods
• new features
• OPENROWSET
• programming
• shredding
• SQL Server
• XML
• XQuery

• Unmatched Nodes in XQuery

  In a previous entry I talked about simulating SQL inner joins with XQuery FLWOR expressions. In this post I'll take a look at finding unmatched nodes in two node sequences - a requirement for implementing outer join-style functionality in XQuery.... Posted Feb 25 2008, 12:53 AM by Mike C with | with no comments Filed under: XML, new features, tutorial, programming, SQL Server, FLWOR, XQuery, function

• Retrieving Recursive Hierarchical Data

  Many people are familiar with the de facto standard hierarchical organizational chart, but the AdventureWorks sample database has some another hidden hierarchical gem. In this post I describe how to retrieve a recursive, nested, hierarchical AdventureWorks Bill of Materials as an XML document.... Posted Feb 15 2008, 09:19 PM by Mike C with | with no comments Filed under: XML, tutorial, programming, SQL Server, development, function, bill of materials

• Loading XML From the File System

  One from the bag o' tricks: the no fuss no muss way to quickly load XML documents from the file system into SQL Server for storage or processing.... Posted Feb 04 2008, 02:00 PM by Mike C with | with no comments Filed under: XML, tutorial, SQL Server, OPENROWSET, bulk load

• Xml Data Type: nodes() Method

  In the second-half of this kick-off double-feature, I'll tell you why SQL Server OPENXML shredding is on my TTMMU ("Things That Make Me Unhappy") shortlist. Here's why it should be on yours too, plus what you can do about it.... Posted Jan 22 2008, 07:44 PM by Mike C with | with no comments Filed under: XML, tutorial, shredding, programming, SQL Server

• Welcome to Pro SQL Server XML

  Welcome to the Pro SQL Server XML (2005, 2008) blog. In this introductory blog, I provide a sample using the xml data type and the nodes() method to shred cached XML query plans on the server. This example demonstrates several new features in addition to the nodes() method, including CROSS APPLY, CTEs, dynamic management functions/views, and more.... Posted Jan 21 2008, 05:38 PM by Mike C with | with 1 comment(s) Filed under: XML, new features, methods, tutorial, introduction