Advantages of SQLXML 3.0 Service Pack 3 for 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

    Requires Free Membership to View

  • 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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.