Before you start installation, verify that your system meets the specified requirements in Chapter 1 "Before You Install".

SQLXML gives an extensive chance to work with XSDs (Xml Schema Definitions).

This chapter describes the SQL/XML JDBC driver and the classes it uses to process SQL/XML queries. It also provides information about connecting to the database and using SQL/XML queries in Java applications.

SQLXML: XML Technology for SQL Server [ppt]

Microsoft's SQLXML 3.0 is a powerful tool for rendering SQL Server 2000 relational data as structured XML documents within SOAP 1.1 response-message payloads.

Well we have used seen a number of articles on this site to show the XML capabilities of SQL Server 2000. Starting from simple FORXML clause to advanced Managed classes have been discussed earlier.

There have been loads of third party tools that have evolved in the recent past to transfer and upload data from one system to another. With XML becoming the defacto standards for communication between various layers of an application we have to take this seriously. Biztalk and many other softwares essentially do this to great effect. We have also discussed one similar functionality that SQL Server inherently supplies, OPENXML.

We have seen a number of articles on how we can retrieve data from SQL Server 2000. But how we can send data to insert, update or delete have not been covered. And here we are look at one of the native features that get bundled with SQLXML 3.0, Updategrams. In this article we will explore how we can use updategrams with simple examples to illustrate us the core features.

There have been a series of articles that have got published till now on how we can use various techonolgies to retrieve data from SQLXML. In this article we would get one step further in analyzing how we can parameterize each of these methods to simulate realtime scenarios. In practical life we would like to filter out select statements criterias. And we in quest to explore each.

Microsoft SQLXML 3.0 supports features that allow you to write applications to access XML data from an instance of Microsoft SQL Server, bring the data into the Microsoft .NET Framework environment, process the data, and send the updates back to SQL Server. The SQLXML managed classes give you an arsenal of methods you can use to capitalize on the Miscrosoft .NET Framework features. In this article lets take a ride on these various methods and how we can use them in paractical scenario.

Microsoft has released a patch for SQLXML that includes updates for the issues that are described in the following Microsoft Knowledge Base articles:

The objective of this session is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries. You will learn about the underlying architecture of using ADO to execute SQLXML queries. Code walkthroughs will be presented to illustrate how to execute different types of SQLXML queries (FOR XML AUTO, Templates, Updategrams, XPath queries against annotated mapping schemas, and applying an XSLT transformation to the result generated when you execute a SQLXML query) using ADO.

See news about SQLXML on the weblogs of sqlxml.org

SQLXML 3.0 - Accessing your data remotely

In that XML-nutty ASP ecommerce site I'm migrating to W2K3 are SQLXML template-derived reports, as in the following example:

A cross-site scripting vulnerability exists in the Microsoft SQLXML HTTP components. This vulnerability could allow an attacker to execute script on a victim's system with the victim's privileges.

Leveraging SQL Server SQLXML Templates Part 2 [pdf]

My previous entry noted that SQLXML 3.0 SP2 Beta 1 is posted, but I have not been successful in getting it to work with Windows 2003 Server yet. For anyone else having difficulty, Bryant Likes posted the steps to make SQLXML work on Windows 2003 Server on SQLXML.org.

The objective of this session is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries. You will learn about the underlying architecture of using ADO to execute SQLXML queries. Code walkthroughs will be presented to illustrate how to execute different types of SQLXML queries (FOR XML AUTO, Templates, Updategrams, XPath queries against annotated mapping schemas, and applying an XSLT transformation to the result generated when you execute a SQLXML query) using ADO. The code samples presented in the slides of this presentation will be written using Visual Basic 6.0. The presentation will not cover the basics of XML (and its related standards XSLT, Path, DOM, and the concept of XML parsers and XSD schemas) and SQLXML. Knowledge of these topics and familiarity with Visual Basic 6.0 and ASP development will be assumed.

I don’t know how many of you out there have been to Don Smith’s Dev4Net blog, but if you are into SQLXML, you should definitely stop by, it is written entirely in SQLXML 3.0, and he has made the source available.