Programming.Microsoft.SQL.Server.2000.with.XML

Introduction Over the past few years, XML has emerged as the computer world’s favorite three-letter acronym. At first, XML was a curiosity about which a few technological boffins were getting a little over-excited—an interesting technology looking for a place to happen. Gradually, however, developers came to realize the enormous po tential of a platform-neutral way to exchange structured data over the Internet, and we started to see people using XML in new and interesting ways. Of course, there’s nothing particularly noteworthy about this trend; in an industry where new technologies are often obsolete before they even get to market, it’s not unusual to see a mass adoption of the latest and greatest technological fashion. But XML has proved to have more staying power than many of the other techniques and technologies that have risen and fallen in the computing world. One reason for XML’s support is that unlike many new ideas, it doesn’t require us to throw away all our old ones. In fact, XML makes it easier to retain your existing systems and integrate them with new ones. It also makes it possible to integrate your applications with those of your trading partners, even if they’re using platforms and systems completely different from yours. Integrating applications and businesses has long been the holy grail for many developers, and as the Internet has become the environment in which more and more development takes place, we’re constantly looking for ways to build integrated applications on the Web. XML is the key to this kind of integration. By adding support for XML to Microsoft SQL Server 2000, Microsoft has made it easier than ever to integrate SQL Server–based solutions with existing systems, Web applications, and trading partners. Who Is This Book For? Let’s start by understanding who this book is not for. It’s not designed to teach you XML (in spite of what the title of this book’s appendix suggests). Bookstores are already filled with shelves groaning under the weight of XML texts, and there’s enough information on the Web to help you become an XML guru, if that’s your ambition in life. I’ve generally assumed in this book that you’re familiar with the basic structure of an XML document and that you’re aware of XML-related technologies such as XSL style sheets and schemas. If you have no working experience with XML, you should read the appendix, "Introduction to XML," before reading the rest of the book. The appendix will familiarize you with basic XML knowledge that you need to work with XML and SQL Server. Similarly, I didn’t write the book with the intention of teaching all there is to know about SQL Server or the Transact-SQL language. In fact, I’m counting on your already being familiar with the basic Transact-SQL statements, such as SELECT, INSERT, UPDATE, and DELETE, and knowing something of the basic architectural and security concepts in SQL Server. I wrote this book for anyone who needs to understand how to use XML to integrate applications or organizations that store data in a SQL Server database. The book covers XML-related functionality in SQL Server 2000 and describes how this functionality can be used to build a solution that exchanges data in XML format. Because a great deal of the emphasis in this book is on Internet-based applications, you’ll need to be familiar with some basic Web-development techniques for the Microsoft Windows platform, such as Microsoft Internet Information Services (IIS), Microsoft Active Server Pages (ASP), Hypertext Markup Language (HTML), and the Hypertext Transfer Protocol (HTTP). This book shows you how to use the XML functionality in SQL Server together with these technologies to build integration solutions that work across the Internet. tential of a platform-neutral way to exchange structured data over the Internet, and we started to see people using XML in new and interesting ways. Of course, there’s nothing particularly noteworthy about this trend; in an industry where new technologies are often obsolete before they even get to market, it’s not unusual to see a mass adoption of the latest and greatest technological fashion. But XML has proved to have more staying power than many of the other techniques and technologies that have risen and fallen in the computing world. One reason for XML’s support is that unlike many new ideas, it doesn’t require us to throw away all our old ones. In fact, XML makes it easier to retain your existing systems and integrate them with new ones. It also makes it possible to integrate your applications with those of your trading partners, even if they’re using platforms and systems completely different from yours. Integrating applications and businesses has long been the holy grail for many developers, and as the Internet has become the environment in which more and more development takes place, we’re constantly looking for ways to build integrated applications on the Web. XML is the key to this kind of integration. By adding support for XML to Microsoft SQL Server 2000, Microsoft has made it easier than ever to integrate SQL Server–based solutions with existing systems, Web applications, and trading partners. Who Is This Book For? Let’s start by understanding who this book is not for. It’s not designed to teach you XML (in spite of what the title of this book’s appendix suggests). Bookstores are already filled with shelves groaning under the weight of XML texts, and there’s enough information on the Web to help you become an XML guru, if that’s your ambition in life. I’ve generally assumed in this book that you’re familiar with the basic structure of an XML document and that you’re aware of XML-related technologies such as XSL style sheets and schemas. If you have no working experience with XML, you should read the appendix, "Introduction to XML," before reading the rest of the book. The appendix will familiarize you with basic XML knowledge that you need to work with XML and SQL Server. Similarly, I didn’t write the book with the intention of teaching all there is to know about SQL Server or the Transact-SQL language. In fact, I’m counting on your already being familiar with the basic Transact-SQL statements, such as SELECT, INSERT, UPDATE, and DELETE, and knowing something of the basic architectural and security concepts in SQL Server. I wrote this book for anyone who needs to understand how to use XML to integrate applications or organizations that store data in a SQL Server database. The book covers XML-related functionality in SQL Server 2000 and describes how this functionality can be used to build a solution that exchanges data in XML format. Because a great deal of the emphasis in this book is on Internet-based applications, you’ll need to be familiar with some basic Web-development techniques for the Microsoft Windows platform, such as Microsoft Internet Information Services (IIS), Microsoft Active Server Pages (ASP), Hypertext Markup Language (HTML), and the Hypertext Transfer Protocol (HTTP). This book shows you how to use the XML functionality in SQL Server together with these technologies to build integration solutions that work across the Internet.