by Alex T. Silverstein and Paul Bertucci
IN THIS CHAPTER
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).