The Microsoft .NET Framework offers a wide variety of XML functionality through the
System.Xml namespace and other related classes. Using the .NET Framework, you can do just about anything you could possibly want with XML, including many XML-specific tasks that are not available directly from Transact-SQL (T-SQL). The .NET Framework's XML functionality is available on the client side and, as you saw in Chapter 8, it is also readily accessible to SQL Server via SQL Common Language Runtime (SQLCLR) integration. In this chapter, I'll look at the
System.Xml namespace and other XML-related tasks you can perform using the Framework's functionality.
The SQL Server
xml data type provides XML Schema validation, ...