title: How do I use AXSD in SQL Server?
body: <p>In SQL Server you can use an XML datatype and map it to relational columns using an AXSD schema.</p>
  
  <blockquote>
    <p>Mapping between XML and relational
    storage  By using an annotated schema
    (AXSD), the XML is decomposed into
    columns in one or more tables. This
    preserves fidelity of the data at the
    relational level. As a result, the
    hierarchical structure is preserved
    although order among elements is
    ignored. The schema cannot be
    recursive.</p>
  </blockquote>
  
  <p>from <a href="http://technet.microsoft.com/en-us/library/bb522493.aspx" rel="nofollow noreferrer">MSDN</a></p>
  
  <p>However I cannot find any documentation on how to do this - or even a good page about AXSD.</p>
  
  <p>Anybody got any good AXSD information. it seems very appropriate to what I want to do (temporarily use XML until i can migrate to something like nHibernate, but still allow a column view of certain pertanent data fields.</p>