Problem solve Get help with specific problems with your technologies, process and projects.

Advantages of SQLXML 3.0 Service Pack 3 for SQL Server

SQLXML 3.0 SP3 allows SQL Server to work transparently with XML data. This tip explains how this add-on works and describes five features to help you handle XML in SQL Server.

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
    This can 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!

Dig Deeper on Enterprise infrastructure management

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.