Chapter 8. XSLT and the SQLCLR
So far I've covered quite a lot of ground discussing native SQL Server 2008 XML functionality. However, there are some things that aren't covered by the native Transact SQL (T-SQL) and
xml data type enhancements in SQL Server. Using Extensible Stylesheet Language Transformations (XSLT) functionality is one area where you have to go outside of the built-in T-SQL functionality and access the .NET functionality available through the SQLCLR (SQL Common Language Runtime).
XSLT is a W3C recommendation for a language for transforming XML documents into other XML documents. In this chapter, I will talk about the W3C XSLT recommendation and the SQLCLR functionality that will enable you to access XSLT functionality directly ...