SQLXML 3.0 Service Pack 3 is an add-on that allows SQL Server to work transparently with XML data. With it you can create an XML view from a dataset and work with the data as if it were an XML file. You can also create a query in Transact-SQL and return the results in XML format, or convert existing XML data into relational table-based data and upload it to a SQL Server 2000 system.
SQLXML 3.0 Service Pack 3 offers several new features for using XML in SQL Server. Here's a rundown of each feature:
- Web services (SOAP) support
This allows SQLXML to receive SOAP HTTP requests to execute stored procedures or run user-defined functions. SQLXML publishes a Web services description language (WSDL) definition so that any SOAP client can make use of it.
- .NET support
This includes managed classes and use of the DiffGram dataset format, which can be used to modify (insert, update or delete) records. (This feature requires the .NET Framework be installed.)
- A revised SQLXMLOLEDB Provider
This allows SQLXML to be accessed through ADO. SQLXMLOLEDB doesn't return rowsets, however; it's only for executing commands and writing to a given output stream.
- Client-side XML formatting
This allows the actual XML formatting to be performed on the client side rather than the server itself, which distributes the workload a little more evenly.
- XML views using annotated XSD schemas
- be used to create an XML view of relational data, called a mapping schema, which is useful if you want to have the actual structure of a dataset travel with it instead of just the data when you return records.
Go to this Microsoft page for the SQLXML download and the full system requirements.
Serdar Yegulalp is the editor of the Windows 2000 Power Users Newsletter. Check out his Windows 2000 blog for his latest advice and musings on the world of Windows network administrators -- please share your thoughts as well!
This was first published in December 2004