Revision: 52822
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at November 2, 2011 05:22 by ezerick
Initial Code
The following example specifies FOR XML AUTO with the TYPE and XMLSCHEMA options. Because of the TYPE option, the result set is returned to the client as an xml type. The XMLSCHEMA option specifies that the inline XSD schema is included in the XML data returned, and the ELEMENTS option specifies that the XML result is element-centric. SQL USE AdventureWorks2008R2; GO SELECT p.BusinessEntityID, FirstName, LastName, PhoneNumber AS Phone FROM Person.Person AS p Join Person.PersonPhone AS pph ON p.BusinessEntityID = pph.BusinessEntityID WHERE LastName LIKE 'G%' ORDER BY LastName, FirstName FOR XML AUTO, TYPE, XMLSCHEMA, ELEMENTS XSINIL;
Initial URL
Initial Description
Initial Title
Fox XML in TSQL
Initial Tags
Initial Language
SQL