How XML can be stored in relational database ?
There are three ways XML can be stored in relational database.
1. XML can stored as text . XML can be stored in text and varchar colums of table. But , it will lose much of value of XML representation. This can be used with any version of SQl server
2. XML can decomposed and stored in multiple relational tables. This alows use of relational technologies.
3. XML can be stored in XML datatype. XML datatype was introduced in SQL Server 2000. Hence, this cannot be used in prior version of SQL 2005.