The Web Server Environment - Database Processing: Fundamentals, Design, and Implementation - page 502

The SQL FOR XML
RAW query

The SQL FOR XML
RAW query results—
click this cell to display
the results in a
separate window

(a) FOr XML raW Query

The SQL FOR XML
RAW query results

(b) FOr XML raW results in the Microsoft SQL Server Management Studio

Figure 11-55
FOr XML raW Examples

Figure 11-56(a) shows the query in the Microsoft SQL Server Management Studio, and
Figure 11-56(b) shows the full results in a separate tabbed window. Here each attribute value
appears as a separate element. The complete output, edited as it would appear in an XML
document (and with MyData tags added to contain the entire data set) is shown in Figure
11-56(c). The XML Schema for this document is shown in Figure 11-56(d), and the graphical
representation of the XML Schema is shown in Figure 11-56(e).