Chapter 41. Using XML in SQL Server 2000


by Alex T. Silverstein and Paul Bertucci

IN THIS CHAPTER

  • Creating a Virtual Directory for Use with SQL Server 2000

  • Exploring Extensible Markup Language (XML)

  • Retrieving Data Using the FOR XML Clause

  • Using FOR XML RAW

  • Using FOR XML AUTO

  • Using FOR XML AUTO, ELEMENTS

  • Using FOR XML EXPLICIT

  • Retrieving XML-Data Schemas

  • Retrieving Binary Data in XML

  • The Basics of XML Path Language (XPath)

  • Using XML in Stored Procedures

  • Using OPENXML to Read XML

  • Using URL Queries

  • Using XML Templates

  • Using XML Updategrams

One of SQL Server 2000's major enhancements is the inclusion of native XML support, enabling developers to execute queries that return results as XML-formatted data, rather than standard rowsets. XML is quickly becoming the dominant format for passing data across networks and between diverse code components . With SQL Server 2000, XML can be passed into and returned from stored procedures, passed directly between SQL Server and the Internet, and much more. Developers also will be leveraging XML via ADO.NET, the full impact of which is discussed in Chapter 46, "SQL Server and the Microsoft .NET Framework." All in all, the .NET Framework is now capable of both XML via the ADO.NET layer and native XML support directly with SQL Server 2000. This chapter will introduce XML concepts and usage examples from SQL Server 2000's point of view. We will be using the Web (IIS) for much of the examples so it should be configured for use with SQL Server (if you haven't already done this).



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net