Browse by Tags

• bill of materials
• development
• FLWOR
• namespaces
• new features
• programming
• SQL Server
• tutorial
• URI
• XML
• XQuery

• Grabbing Node Names and Values Pt. 2

  As a follow-up to my last post on grabbing node names and values , I was asked about grabbing URIs from more complex XML documents. The following query is the result of that discussion: DECLARE @x xml ; SET @x = N '<?xml version = "1.0"... Posted Mar 09 2008, 12:55 AM by Mike C with | with no comments Filed under: XML, SQL Server, XQuery, function, URI, namespaces

• Grabbing Node Names and Values

  I got a question the other day about grabbing node names and values from an XML document. The person asking was using string parsing with the SUBSTRING function to split out names from content based on '>' characters in the XML string. Not... Posted Mar 07 2008, 11:51 AM by Mike C with | with no comments Filed under: XML, XQuery, function

• 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