Writing Stored Procedures for Microsoft SQL Server

Chapter 14. SQL Server XML Support

IN THIS CHAPTER

• What is XML?

• XML and HTML

• Microsoft and XML

• XML fundamentals

• Using XML with SQL Server and Internet Information Server's server extensions

• SQL XML

• The FOR XML clause

• Formatting data with XSL

• XML and style sheets

• Putting it all together

• Update grams

• Setting basic security

• Security configuration for URL access

XML is designed to work on the Internet. Although this is certainly a primary factor in its design, XML is also intended to work in many other environments outside the WWW. For example, publishing, data interchange, and many commercial applications use XML. For XML to be used successfully in such a wide variety of applications, it had to be very simple, very powerful, and very easy to implement even ...