generate XML against XSD from SQL db

[leoliang]

Hi,



I need to export a XML file against XSD file from a table in my SQL database.

the XSD file is given by another company, my table contains all the required data.

Could anyone please help me this?

thanks

 

[johnv20]

If I understand your question correctly then from BOL

<xsd:schema xmlns:xsd="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema"[/URL] 
            xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
  <xsd:element name="Order" sql:relation="Sales.SalesOrderHeader">
     <xsd:complexType>
       <xsd:attribute name="SalesOrderID" type="xsd:string" /> 
       <xsd:attribute name="CustomerID"   type="xsd:string" /> 
       <xsd:attribute name="OrderDate"    type="xsd:date" /> 
       <xsd:attribute name="DueDate"  /> 
       <xsd:attribute name="ShipDate"  type="xsd:time" /> 
     </xsd:complexType>
  </xsd:element>
</xsd:schema>

if you want to explicity map the schema & your sql data then just add the sql:field identifier - for example

<xsd:attribute name="ShipDate"  type="xsd:time" sql:field="TimeStamp" />