XML Integration in SQL Server 2005

XML is now a data type in SQL Server which adds a lot of functionality for storage and manipulation of XML. Now developers can type a field as XML and use methods and calls to easily produce solid XML code. I have collected a couple of links in overview of this topic. I also have provided a link that shows how to pass in XML as a parameter into SQL Server 2005.





Link: http://url123.com/nw8rk
Link: http://url123.com/nacrr
XML as param: http://url123.com/navrg
Illegal Chars in XML: http://url123.com/na6rn