Summary

for RuBoard

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.

for RuBoard


The Guru[ap]s Guide to SQL Server[tm] Stored Procedures, XML, and HTML
The Guru[ap]s Guide to SQL Server[tm] Stored Procedures, XML, and HTML
ISBN: 201700468
EAN: N/A
Year: 2005
Pages: 223

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