Looking at the XML Data Type with SQL Server 2005
Question: My company is in the process of designing a new internal application. We have made the decision to go with SQL Server 2005 for our back end database and have been pretty impressed with we have seen so far. As I began the design I have been doing a lot of reading quick prototyping to validate ideas. I am trying to understand the new XML data type a bit better. We have some data that we had planned on storing in XML outside of the database but I think this would be a better solution. However, I am having a hard time figuring out how I can create tables and structures using the type and schema validation. Any ideas or examples you may have on how this can be done?