如何将XML文件数据插入SQL Server [英] How to insert XML file data into SQL server

问题描述

我有一个包含大量数据的XML文件。我想从XML文件批量插入任何5个属性到SQL server.please帮助我们....



我尝试了什么：



我的示例XML文件..

我提到过2个属性（相同的属性重复多次），就像这里有很多属性一样..

i希望批量插入（所有数据相同的属性名称）任意2个属性数据到SQLserver中

I have a XML file with lot of attributes with lot of data.I want to bulk insert any 5 attribute from XML file to SQL server.please help me guys....

What I have tried:

My sample XML file..
I mentioned 2 attributes(same attribute repeated many times),like this lot of attributes there..
i want to bulk insert(all data same attribute name) any 2 attributes data into SQLserver

<<fsxml>
  <report>
    <SchemaList>
      <Schema>PDU_FORMULA_DEV_001.xsd</Schema>
      <Schema>PDU_ITEM_DEV_001.xsd</Schema>
    </SchemaList>
    <object>
 <FSDATAMATRIX>
        <TABLE_CODE>GRADING_REQUIREMENTS</TABLE_CODE>
        <SYMBOL>FORMULA</SYMBOL>
        <VIEW_ID>0</VIEW_ID>
        <DESCRIPTION>Grading Requirements</DESCRIPTION>
        <ROW_ADD_IND>1</ROW_ADD_IND>
        <OWNER_CODE>FSI</OWNER_CODE>
        <GROUP_CODE>ADMIN</GROUP_CODE>
        <OWNER_SECURITY>15</OWNER_SECURITY>
        <GROUP_SECURITY>15</GROUP_SECURITY>
        <ROLE_SECURITY>15</ROLE_SECURITY>
        <DB_TABLE_NAME>FORMULA0</DB_TABLE_NAME>
        <SORT_ORDER>LINE_ID ASC</SORT_ORDER>
      </FSDATAMATRIX>
<FSFORMULADOC>
        <DOC_ID>101015</DOC_ID>
        <FUNCTION_CODE>PRODUCT_SUMMARY</FUNCTION_CODE>
        <TEXT_DATA />
        <ATTCH_CNT>0</ATTCH_CNT>
        <ATTCH_TYPE>0</ATTCH_TYPE>
        <DOC_ORDER>1</DOC_ORDER>
        <DOC_DESCRIPTION>Product Summary</DOC_DESCRIPTION>
        <FORMULA_CODE>701399-ML81</FORMULA_CODE>
        <VERSION>01</VERSION>
        <SRVROW_ID>1</SRVROW_ID>
        <FUNCTION_CODE_LABEL>PRODUCT_SUMMARY</FUNCTION_CODE_LABEL>
      </FSFORMULADOC>
 </object>
  </report>
</fsxml>

推荐答案

将数据从XML文件导入和处理到SQL Server表 [ ^ ]

Chech This

Importing and Processing data from XML files into SQL Server tables[^]
Chech This

这篇关于如何将XML文件数据插入SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！