Think back to Chapter 4, "Accessing SQL 2000 via HTTP," and you'll realize that we covered a large amount of information and coding techniques in that chapter. This information enables us to generate XML documents in several ways: by calling stored procedures, by calling template files, and by directly stating SQL in URLs. The template file's contents also can be listed directly in a URL. In addition, we can modify the returned document to suit our requirements by employing XSLT stylesheets. Even though we learned how to accomplish all this, we still have the full version of the XPath expression and queries to learn, along with the FOR XML and OPENXML Microsoft extensions and Microsoft's version of schemas, XML-Data Reduced (XDR) schemas. We tackle the latter subject matter, XDR schemas, in this chapter. In Chapter 1, "XML," I mentioned that Microsoft's version on XML schemas differs from the schemas documented in the W3C specification. This came about from Microsoft taking the initial specification, immediately adopting it, modifying it accordingly , and not paralleling the W3C specification. In this chapter, you'll see just how different the two specifications are. This chapter will cover the following topics:
|