XML Workshop - A series of XML articles published at www.sqlservercentral.com

1. XML Workshop I - Generating XML with FOR XML - A short article that explains how to generate XML output with TSQL keyword FOR XML with AUTO and RAW directives
2. XML Workshop II - Reading values from XML variables - This article explains how to read values from an XML variable using XQuery (TSQL)
3. XML Workshop III - FOR XML PATH - This article shows several examples that generates XML output using FOR XML with PATH
4. XML Workshop IV - FOR XML EXPLICIT - Explains the usage of EXPLICIT with FOR XML
5. XML Workshop V - Reading Values from XML Columns - This article gives a closer look into XQuery and shows examples of reading values from XML columns.
6. XML Workshop VI - Typed XML and SCHEMA Collection - Introduces TYPED XML and XML SCHEMA COLLECTIONS
7. XML Workshop VII - Validating values with SCHEMA - Shows how to do Data Type validations using an XML SCHEMA COLLECTION
8. XML Workshop VIII - Custom Types and Inheritance - This article explains how to create custom types and create types that inherit from other types. Usage of custom types can make the XML schema less complex and easier to understand and manage
9. XML Workshop IX - Mixed Types - This article introduces ComplexTypes having Mixed content model
10. XML Workshop X - Working with namespaces - Introduces XML namespaces and shows how to generate XML documents having namespace declaration using TSQL keyword WITH XMLNAMESPACES
11. XML Workshop XI - Default Namespaces - Introduces Default Namespaces
12. XML Workshop XII - Parsing a delimited string - This workshop builds a function that parses a delimited string using XQuery
13. XML Workshop XIII - XSD And Variable Content Containers - XSD performs very strict validation on the content of an XML element or attribute. This article explains how to define elements that can take variable content
14. XML Workshop XIV - Generating an XML Tree - Explains how to generate an XML tree using a recursive CTE and FOR XML EXPLICIT
15. XML Workshop XV - Accessing FOR XML results with ADO.NET - This article explains how to access the output of FOR XML from ADO.NET
16. XML Workshop XVI - Shaping the XML results - Shows a few more examples that generates XML output using FOR XML with AUTO, PATH and EXPLICIT
17. XML Workshop XVII - Writing a LOOP to process all XML nodes - Explains how to write a loop that iterates over all the nodes of an XML document
18. XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL - Shows how to generate an RSS 2.0 feed using FOR XML PATH
19. XML Workshop XIX - Generating an ATOM 1.0 Feed with TSQL - Shows how to generate an ATOM 1.0 feed using FOR XML PATH
20. XML Workshop XX - Generating an RSS 2.0 Feed with TSQL(SQL server 2000) - Explains how to generate an RSS 2.0 FEED with FOR XML EXPLICIT
21. XML Workshop XXI - Generating an ATOM 1.0 Feed with FOR XML EXPLICIT - Explains how to generate an ATOM 1.0 FEED with FOR XML EXPLICIT (SQL Server 2000)
22. XML Workshop XXII - A TSQL RSS Library - This article presents an RSS Library: a function that can generate an RSS 2.0 FEED from an XML variable. You can use this function to generate the RSS feeds needed for your application/web site.
23. XML Workshop XXIII - A TSQL ATOM Library – This article presents a function that can generate an ATOM 1.0 feed. It take the input information in two XML variables and generates the ATOM feed based on the information in the XML variables.
24. XML Workshop 24 - Modifying XML Documents Using XQuery Part 1 – This articles presents close to two dozen examples that demonstrates different ways of deleting attributes from an XML document.

See Also

1. XQuery Tutorial
2. SQLXML Tutorial