怎样将数据库内容导出到XML文件当中？？？？？？？？？（急急急！在线等待解决！）

Question

数据是：
  c0       c1       c2
  01    零售客户  零散客户
  02    批发客户  批发客户希望导出以下个是的文件：<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:updatable='true'>
<s:AttributeType name='c0' rs:name='代码' rs:number='1' rs:write='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='255' rs:precision='0' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='c1' rs:name='名称' rs:number='2' rs:write='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='255' rs:precision='0' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='c2' rs:name='全名' rs:number='3' rs:write='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='255' rs:precision='0' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='c3' rs:name='审核人' rs:number='4' rs:write='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='255' rs:precision='0' rs:maybenull='false'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
  <rs:insert>
     <z:row c0='01' c1='零售客户' c2='零散客户>
     <z:row c0='02' c1='批发客户' c2='批发客户'/>
  </rs:insert>
</rs:data>
</xml>请各位大虾附上操作代码，谢谢各位！（新手）

Answer 1

导入文件
ADOQuery.SaveToFile('test.xml', dfXML);
导入到数据库
ADOQuery.LoadFromFile('test.xml');
First;
Insert;
.....
while not Eof do
Next;

Answer 2

[转]导入 xml　文件
------------------------------------------------------
DECLARE @idoc int
DECLARE @doc varchar(1000)
--sample XML document
SET @doc ='
<root>
  <Customer cid= "C1" name="Janine" city="Issaquah">
      <Order oid="O1" date="1/20/1996" amount="3.5" />
      <Order oid="O2" date="4/30/1997" amount="13.4">Customer was very satisfied
      </Order>
   </Customer>
   <Customer cid="C2" name="Ursula" city="Oelde" >
      <Order oid="O3" date="7/14/1999" amount="100" note="Wrap it blue 
             white red">
            <Urgency>Important</Urgency>
            Happy Customer.
      </Order>
      <Order oid="O4" date="1/20/1996" amount="10000"/>
   </Customer>
</root>
'
-- Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc-- Execute a SELECT statement using OPENXML rowset provider.
SELECT *
FROM OPENXML (@idoc, '/root/Customer/Order', 1)
      WITH (oid     char(5), 
            amount  float, 
            comment ntext 'text()')
EXEC sp_xml_removedocument @idoc