ExtremeExperts

In a relational database such as Microsoft SQL Server 2000, all operations on tables in a database produce results in the form of a table. Web application programmers however, are more familiar with working with hierarchical representations of data in XML or HTML documents. SQL Server 2000 introduces robust support for XML including: the ability to access SQL Server through a URL, support for XML-Data schemas, ability to retrieve and write XML data and enhancements to the OLEDB provider that allow XML documents to be exchanged.

In this chat, we shall discuss about these various features and how to leverage SQL Server as an XML delivery platform along with QA on each of these features.

Since this Chat went for a two part series. You can catch the transcripts of the same Part I and Part II.

- Related Links

Exploring FORXML Clause

: Understand the basics of getting XML from SQL Server 2000.

Understanding and Using SELECT ... FOR XML

: This article provides an overview of the various FOR XML options available in SQL Server.

Understanding EXPLICIT XML Formatting

: This article provides an overview of how to use the FOR XML EXPLICIT formatting in SQL Server.

Exploring OPENXML

: Understand the basic ways in accessing and using OPENXML to turn XML data into relational data.

Reading and Writing XML

: This article provides an overview of how to use the OPENXML command of SQL Server to play around with XML.

Customizing URL Queries

: This article looks at how you can customize the output of a URL-based query using stylesheets.

Configuring Web Queries In SQL Server

: This article looks at how you can configure SQL Server to accept URL-based queries.

Passing Parameters in URL Queries

: This article looks at how you can call URL queries with parameters.

Specifying Client Side Formatting For Template Queries

: This article provides an overview of how to apply formatting on the client for URL queries.

Calling Stored Procedures through URL queries

: This article looks at how you can call stored procedures (with and without parameters) via a URL query.

Understanding Query Templates

: This article provides an overview of how to use query templates to access SQL Server data via a URL.

Generating Template using VS .NET

: Here are some easy steps on how we can generate Templates using VS .NET IDE.

Parametrizing in SQLXML using VB .NET

: We will take a closer look at how we can parametrize the various methods used to access XML data from SQLXML Managed APIs.

Using ADO to access SQLXML functionalities

: In this article learn to build client applications or business components that retrieve XML data from SQL Server and return the results as XML format using ADO.

Using XSDs

: Take a look at how we can use XSDs in conjunction with SQLXML to retrieve data from SQL Server 2000.

Generating Simple XSDs using VS .NET

: This is an interesting implementation to generate XSD schemas using the VS .NET IDE.

Using Updategrams

: Learn how to use Updategrams in SQLXML. This extended feature allows you to Insert/Update and Delete records from SQL Server 2000. Learn more about this in this simple article.

Managed SQLXML Classes

: In this article we would take a sneak preview of how SQLXML Managed classes can be used.

Using XML Bulk Upload in SQLXML

: Article oulines a simple XML Bulk Upload process using the SQLXML APIs and VB .NET.

Guidelines and Limitations of XML Bulk Load

: MS Article outlines the limitation of using Bulk Upload.

Books for reference:

SQL Server 2000 XML Distilled

Professional SQL Server 2000 XML

The Guru's Guide to SQL Server Stored Procedures, XML, and HTML

Programming Microsoft SQL Server 2000 With XML