SQL Server And XML - Workshop

SQL Server And XML - XML Workshop


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
XML Workshop II - Reading values from XML variables - This article explains how to read values from an XML variable using XQuery (TSQL)
XML Workshop III - FOR XML PATH - This article shows several examples that generates XML output using FOR XML with PATH
XML Workshop IV - FOR XML EXPLICIT - Explains the usage of EXPLICIT with FOR XML
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.
XML Workshop VI - Typed XML and SCHEMA Collection - Introduces TYPED XML and XML SCHEMA COLLECTIONS
XML Workshop VII - Validating values with SCHEMA - Shows how to do Data Type validations using an XML SCHEMA COLLECTION
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
XML Workshop IX - Mixed Types - This article introduces ComplexTypes having Mixed content model
XML Workshop X - Working with namespaces - Introduces XML namespaces and shows how to generate XML documents having namespace declaration using TSQL keyword WITH XMLNAMESPACES
XML Workshop XI - Default Namespaces - Introduces Default Namespaces
XML Workshop XII - Parsing a delimited string - This workshop builds a function that parses a delimited string using XQuery
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
XML Workshop XIV - Generating an XML Tree - Explains how to generate an XML tree using a recursive CTE and FOR XML EXPLICIT
XML Workshop XV - Accessing FOR XML results with ADO.NET - This article explains how to access the output of FOR XML from ADO.NET
XML Workshop XVI - Shaping the XML results - Shows a few more examples that generates XML output using FOR XML with AUTO, PATH and EXPLICIT
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
XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL - Shows how to generate an RSS 2.0 feed using FOR XML PATH
XML Workshop XIX - Generating an ATOM 1.0 Feed with TSQL - Shows how to generate an ATOM 1.0 feed using FOR XML PATH
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