XML Manipulation in SQL Server 2005
I am now having to represent xml data along with my relational data and thought I would share some resources on this subject. Apparently SQL Server 2005 provides 5 functions for T-SQL that allow fast CRUD for XML. You can also type your xml so that your xml is checked for type safe on an insert/update with xml schemas.
MSDN Full Explaination