Sunday, March 08, 2009

SQL Server 2008 XPath Functions

The 2008 version of SQL Server has not introduced as many changes to its XPath implementation as one might have expected; nonetheless, two additional XPath functions have been added.

In fact, I'm very sure many of us have missed both of them ever since SQL Server 2005:

  • lower-case() – returns the text of the target node in lower case; and
  • upper-case() – returns the text of the target node in upper case.

Of course I've made sure this change is reflected in my older posts dealing with this particular subject:

For some time now I've also been looking more closely at the differences between SQL Server 2005 and SQL Server 2008 regarding the performance of XML queries, and (as soon as I find the time to go through my findings and – ideally – get some additional information) I'll post back with the results.