The Gurus Guide to SQL Server Stored Procedures, XML, and HTML [Electronic resources]

Ken Henderson

نسخه متنی -صفحه : 223/ 127
نمايش فراداده

Summary

In this chapter we explored FOR XML in detail, and also took a look at mapping schemas. FOR XML allows us to translate a SQL Server result set into XML, giving us a great deal of control over how that XML is formatted. Mapping schemas also provide a mechanism for retrieving SQL Server data in XML format. They provide a greater degree of control than FOR XML, but they're also more complicated to use.