none
Transact SQL XML output

    Question

  • I am fairly new to XML and have been doing some research.

    I need to be able to create the following XML output from a couple of SQL tables

    Table 1
    Fielda (primary key)
    Fieldb
    Fieldc

    Table
    FieldD (foreign key)
    fieldE

    <?xml version="1.0" encoding="UTF-8"?>
    <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" version="1.0">
    <xs:element name="examplea " >
    <xs:element name="schemaVersion" type="xs:decimal" use="required" fixed="1.0" />
    <xs:complexType >
    <xs:sequence>
    <xs:element name="cnDetail" minoccurs="1" maxoccurs="3000">
    <xs:complexType>
    <xs:sequence >
    <xs:element name="fielda" type="string" maxlength="50"/>
    <xs:element name="fieldb" type="string" maxlength="50"/>
    <xs:element name="fieldc" type="date"/>
    <xs:element name="fieldd" type="integer" maxlength="10"/>
    <xs:element name="fielde" type="string" maxlength="20"/>
    <xs:restriction>
    <xs:enumeration value="A"/>
    <xs:enumeration value="B"/>
    <xs:enumeration value="C"/>
    </xs:restriction>
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    </xs:schema>

    Is it possible to create this output in SQL Server?
    Tuesday, July 23, 2013 8:57 PM

Answers

All replies