I don't understand why anyone would want to store pure XML data in SQL. Why not just parse the XML and store the information contained in "normal" (e.g. int, varchar) database fields?
TIA,
Barkingdog
Check http://msdn2.microsoft.com/en-us/library/ms187508.aspx, in particular the section "relational or XML data model" to find reason when it makes sense to use the XML data type in SQL server 2005.
No comments:
Post a Comment