xml数据导入sqlserver2005

<?xml version="1.0" standalone="yes"?>
<user>
    <ExternalNum>0</ExternalNum>
    <LoginName>admin</LoginName>
    <LastName>admin</LastName>
    <FirstName>admin</FirstName>
    <Password>21232F297A57A5A743894A0E4A801FC3</Password>
    <UserCategory>20012</UserCategory>
    <CustomerID>30000001</CustomerID>
    <Emailaddress>[email protected]</Emailaddress>
    <FixedPhone_PreNum>10</FixedPhone_PreNum>
    <FixedPhone_1>62668480P8003</FixedPhone_1>
    <FixedPhone_2 />
    <MobilePhone_1 />
    <MobilePhone_2 />
    <QQ />
    <MSN />
    <Birthday>1980-01-01T00:00:00+08:00</Birthday>
    <ZIPCode />
    <Division>120002</Division>
    <Status>2</Status>
    <LoginStatus>20010</LoginStatus>
    <Visable>true</Visable>
    <Sex>20025</Sex>
    < AgreeMent>
         <ImportID>1</ImportID>
         < User_ExternalNum > HS-11080001 </ User_ExternalNum >
         <AgrMntNum>00076348</AgrMntNum>
    <AuthCode>000001</AuthCode>
    <ExternalNum>AHW420009</ExternalNum>
    <Status>20011</Status>
    <SaleOrderNum>00450701</SaleOrderNum>
    <SaleRegister>杜高明</SaleRegister>
     <AgrMntBarCode>HS00076348</AgrMntBarCode>
    <Partner>180036</Partner>
     <Customer>30000001</Customer>
< AgreeMentItem>
<ImportID>2759</ImportID>
               <Agreement_ExternalNum>40002759</Agreement_ExternalNum>
     <AgrMntItemNum>1</AgrMntItemNum>
     <ExternalNum>FJW500010</ExternalNum>
    <TrnsctnPrice>279.2000</TrnsctnPrice>
     <ClearPrice>105.0000</ClearPrice>
     <Quantity>1</Quantity>
     <InvoiceNum>00143446</InvoiceNum>
     <Completed>2010-03-28T00:00:00+08:00</Completed>
     <SaleOrderNum>276323</SaleOrderNum>
     <SaleOrderItemNum>1</SaleOrderItemNum>
    <ServiceProduct>130103</ServiceProduct>
    <AvalibFrom>2011-03-28T00:00:00+08:00</AvalibFrom>
     <AvalibTo>2012-03-27T00:00:00+08:00</AvalibTo>
     <ExtendPeriod>1</ExtendPeriod>
    <Avalib>true</Avalib>
< AgrMntItem_Ast>
                       < AgreeMentItem_ExternalNum> </ AgreeMentItem_ExternalNum>
                       <Asset_ExternalNum></Asset_ExternalNum>
                       <Avalib></Avalib>
                       <DESC></DESC>
     < Asset>
< ImportID > </ ImportID >
                           < ExternalNum ></ ExternalNum >
                           < Name ></ Name >
                           < Status ></ Status >
                           < Caption></ Caption>
                           < ParentID_ExternalNum></ ParentID_ExternalNum>
                           < Customer></ Customer>
                           < User_ExternalNum></ User_ExternalNum>
                           < Division></ Division>
                            < Place></ Place>
                           < Prod></ Prod>
                           < Mounted></ Mounted>
                           < WarrantyPeriod></ WarrantyPeriod>
                           < ProductBrand></ ProductBrand>
                           < ProductCategory></ ProductCategory>
                            < ProdBrandName></ ProdBrandName>
                          < ProdCategory></ ProdCategory>
                          < ProdTradeName></ ProdTradeName>
                           < ProdModelNum></ ProdModelNum>
                           < ProdSeries></ ProdSeries>
                           < InvoiceNum></ InvoiceNum>
                           < TrnsctnPrice></ TrnsctnPrice>
                           < SerialNum></ SerialNum>
                           < AssetNum></ AssetNum>
                           < Completed></ Completed>
                           < Class></ Class>
                          < Avalib></ Avalib>
                          < Desc></ Desc>
   </ Asset>
   </ AgrMntItem_Ast>
      </ AgreeMentItem>
   < /AgreeMent>
</user>
首先大家看我定义的这个xml格式是否正确将这个xml导入数据库中的五个表中user AgreeMent AgreeMentItem AgrMntItem_Ast Asset
这五个表是有主外键顺序的，