XMLTextWriter & XMLTextReader - ASP Alliance

XMLTextWriter & XMLTextReader - ASP Alliance
This article describes how to write pre-defined XML to a file by using XmlTextWriter class. XmlTextWriter provides a fast, forward-only way of generating XML documents without the overhead of a DOM. …

SQL Server Central: Generating an ATOM 1.0 Feed with FOR XML EXPLICIT

XML Workshop XXI - Generating an ATOM 1.0 Feed with FOR XML EXPLICIT - SQL Server Central

Generating an RSS 2.0 Feed with TSQL - SQL Server Central

Generating an RSS 2.0 Feed with TSQL - SQL Server Central

Generating an RSS 2.0 Feed with TSQL(SQL server 2000) - SQL Server Central

XML Workshop XX - Generating an RSS 2.0 Feed with TSQL(SQL server 2000) - SQL Server Central

Generating an ATOM 1.0 Feed - SQL Server Central

XML Workshop XIX - Generating an ATOM 1.0 Feed - SQL Server Central

Generating an RSS 2.0 Feed with TSQL - SQL Server Central

XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL - SQL Server Central

Generating an ATOM 1.0 Feed - SQL Server Central

Generating an ATOM 1.0 Feed - SQL Server Central

Generating RSS/ATOM feeds with TSQL

SQL Server And XML - Generating RSS/ATOM feeds with TSQL


XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL - If you are already on SQL Server 2005, you could benefit from this this approach. This article shows the code that generates an RSS 2.0 feed using FOR XML with PATH. PATH is introduced with SQL Server 2005 and hence if you are working with SQL Server 2000, you cannot use this approach.
XML Workshop XIX - Generating an ATOM 1.0 Feed with TSQL - This article shows the code that generates an ATOM 1.0 feed using TSQL keyword FOR XML with PATH. Again, this is specific to SQL Server 2005/2008. If you are working with SQL Server 2000, then you cannot use the approach explained in this article.
XML Workshop XX - Generating an RSS 2.0 Feed with TSQL(SQL server 2000) - Well, this is for SQL Server 2000. This article shows the code needed to generate an RSS 2.0 feed using FOR XML with EXPLICIT. EXPLICIT is available in SQL Server 2000/2005/2008 and hence this approach will suite you, if you are working with SQL Server 2000. The code using EXPLICIT might look really complex. So, this code may be ideal only if you are working with SQL Server 2000. If you are on 2005/2008, the approach using PATH will be recommended.
XML Workshop XX - Generating an ATOM 1.0 feed with TSQL using FOR XML EXPLICIT - This is the ATOM 1.0 version of the above code. This article is not published yet. I will update the link once the article is published.
XML Workshop XV - Accessing FOR XML results with ADO.NET - You might need this if you are generating your RSS/ATOM feeds in TSQL. This explains how to pass the XML results to your .NET application. This article has VB.NET and C#.NET sample code (ADO.NET) that explain how call a stored procedure that returns an XML stream and access the XML document returned by the stored procedure

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