Browse by Tags

• auditing
• bill of materials
• book
• bulk load
• contest
• development
• FLWOR
• free
• function
• introduction
• logging
• methods
• namespaces
• new features
• OPENROWSET
• programming
• shredding
• SQL Server
• trigger
• tutorial
• URI
• XQuery

• XML Puzzle Contest Winners

  In the last entry I promised to share the answer to the XML puzzle today. Here's a quick recap of the question - SQL 2005 BOL gives the following example of a full-text search XML thesaurus file: <XML ID="Microsoft Search Thesaurus">... Posted Jun 20 2008, 07:18 PM by Mike C with | with no comments Filed under: XML, programming, SQL Server, contest, free

• XML Puzzle

  How well do you know XML? Solve this XML puzzle and you can win a copy of the book Pro SQL Server 2008 XML!... Posted May 27 2008, 09:23 PM by Mike C with Filed under: XML, SQL Server, development, contest, book, free

• 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

• Inner Joins in XQuery

  In this post we consider how to perform classic "inner joins", as a special case of "cross joins", using XQuery FLWOR expressions.... Posted Feb 11 2008, 12:54 AM by Mike C with | with no comments Filed under: XML, programming, SQL Server, development, FLWOR, XQuery

• 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

• Create a Dynamic Logging Trigger With XML

  Triggers are a useful tool for logging DML actions and auditing data changes to tables. But wouldn't it be great if you could write just one trigger and use it on any table? And if the table structure changed the trigger would automatically adjust with no work on your part? With FOR XML and catalog views we can do just that.... Posted Jan 26 2008, 08:47 PM by Mike C with | with no comments Filed under: XML, new features, programming, SQL Server, auditing, logging, trigger

• 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