Summary
In this chapter, I discussed the features of Microsoft SQL Server 2000 that enable you to work with XML and relate XML documents and SQL Server database objects. I showed you several ways to retrieve data, including the FOR XML clause, templates, XML views, and XPath queries.
You learned how to communicate with SQL Server across the HTTP protocol by formatting your requests, using various methods, in XML. I also discussed some tips and tricks that should make building XML views simpler than writing them entirely by hand.
Finally, the OPENXML feature enables you to open XML documents on SQL Server so you can query and insert data into your databases directly from the XML documents. Still more features are available with SQL Server. I recommend ...
Get XML and SQL: Developing Web Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
