The latest technology buzz is Web services. Terms such as Simple Object Access Protocol (SOAP), Web Services Description Language (WSDL), and Universal Description, Discovery, and Integration (UDDI) now appear in almost all marketing materials about XML and the Internet. But how are Web services relevant to you as a SQL Server professional?

This is something that many people have been waiting for. It was posted yesterday in the newsgroups but I missed it since the MS news servers were having problems.

Learn about the guidelines for XML data modeling and usage in SQL Server "Yukon", and see illustrative examples. To get the most from this paper, you should have a basic understanding of XML features in the context of SQL Server.

Take a look at the bridges that SQLXML provides between SQL Server 2000 and the .NET Framework.

Sick of updating your MySQL database to add new fields half way through a project? In this article Bjorn discusses his PHP class that you can use to make changes to your MySQL database on the fly!

15 Second's XML section focuses on Server-side XML and XSL processing using ASP.

When you get a message like this turn off friendly HTTP error messages in IE. To do this go to Tools -> Internet Options -> Advanced. Uncheck show friendly HTTP error messages. Once you have done this you should get a more detailed message which will point you to the real problem.

In this FAQ you will get the answer.

The CommandText property should be used when you are just passing in some text. The benefit is that you do not have to load the text into a stream to pass it.

If your primary key is an identity column it will not be included in the result set. The easiest way to test this is to use a select in place of an update.

I use this technique quite often when I work with dynamic SQL. Here is one sample that I posted a while back in the newsgroups.

Using client side XML with ADO is an effective method to create XML from existing stored procedures. However, the method for using this is not obvious (nor found in the documentation). For this example we will use the Northwind database and a very simple stored procedure:

Microsoft® SQL Server 2000™ shipped more than a year ago with built-in support for storing and retrieving XML data. Knowing ongoing work would be required after the release of SQL Server 2000 in order to stay current with evolving W3C standards for XML, Microsoft began releasing fully-supported, XML feature packs to the Web in the months after the release of SQL Server 2000. Available as a free download, these XML feature packs—called SQLXML (XML for SQL Server)—extend the XML capabilities of SQL Server 2000.

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. My earlier articles about SQLXML 3.0 emphasize generating document/literal XML Web services from existing stored procedures or table-returning functions (see Additional Resources).

Microsoft® SQL Server™ 2000 shipped more than a year ago with built-in support for storing and retrieving XML data. Knowing ongoing work would be required after the release of SQL Server 2000 in order to stay current with evolving W3C standards for XML, Microsoft began releasing fully-supported, XML feature packs to the Web in the months after the release of SQL Server 2000. Available as a free download, these XML feature packs—called SQLXML (XML for SQL Server)—extend the XML capabilities of SQL Server 2000.

The RTM version of SQLXML 3.0 moves from attribute-centric to element-centric XML rowsets and returns DataSet objects from SQL Server 2000 stored procedures.

"MSSQLCity.Com - the site dedicated to providing useful information for IT professionals using Microsoft SQL Server. This site contains SQL Server Articles, FAQ, Scripts, Tips and FREE Test Exams."

The remote host is running SQLXML. There are flaws in it which may allow a remote attacker to execute arbitrary code on this host.

It should be supported in the next version of SQLXML.

In addition to the information below, take a look at this FAQ at SQLTEAM.com. The solution shown at SQLTEAM.com does not have a size limitation which some people have reported with the solution shown below.