An article length piece which demonstrates how and when to implement the XML data type into an SQL Server project. The article covers a real life example used within a clinical application.
Example SQL code shows how to create an XML field within a table, how to index both the XML paths and data values. A sample search query is given showing how to search particular XML nodes for a given value.
Approx 2,200 words.