如何从sql server 2008的.XML文件中检索数据。 [英] How to retrieve data from .XML file of sql server 2008 .

问题描述

如何从sql server 2008 r2中的XML文件中获取数据。实际上我无法检索不超过10000行的数据。我试图获得更多行但在10000行数据截断后。我想要的是检索97047行。怎么做？

.XML文件中的演示数据如下：

 <   BudgetInfo  >  
 <   BudgetHead  >  2202-02-109 -01-00 <   / BudgetHead  >  
 <   ObjectHead  >  01 <   / ObjectHead  >  
 <   PlanNonPlan  >  N <   / Pla nNonPlan  >  
 <   VotedorCharted  >  V <   / VotedorCharted  >  
 <   officeid  >  0 <   / officeid  >  
 <   DemandNo  >  24 <   / DemandNo  >  
 <  金额 >  0.0000 <   / amount  >  
 <   / BudgetInfo  >  

想要将数据存储在单个变量中。

解决方案

试试这些..

http://dba.stackexchange.com/questions/1473/read-xml-file- in-sql-server-2008 [ ^ ]

http://pratchev.blogspot.com/2008/11/import-xml-file-to-sql-table.html [ ^ ]

和第2部分它..

http://www.smallworkarounds.net/2009/07/sending- list-of-complex-objects-to-sql.html [ ^ ]

请参考这篇文章和源代码，您将获得解决方案



XML文件到SQL数据库 [ ^ ]

how to get data from XML file in sql server 2008 r2. Actually I am not able to retrieve data not more than 10000 rows. I tried to get more rows but after 10000 rows data truncates. What i want is to retrieve 97047 rows.How to do it?
Demo data in .XML file is like:

<BudgetInfo>
  <BudgetHead>2202-02-109-01-00</BudgetHead>
  <ObjectHead>01</ObjectHead>
  <PlanNonPlan>N</PlanNonPlan>
  <VotedorCharted>V</VotedorCharted>
  <officeid>0</officeid>
  <DemandNo>24</DemandNo>
  <amount>0.0000</amount>
</BudgetInfo>

Want data to be stored in single variable.

解决方案

Try these..
http://dba.stackexchange.com/questions/1473/read-xml-file-in-sql-server-2008[^]
http://pratchev.blogspot.com/2008/11/import-xml-file-to-sql-table.html[^]
And 2nd part of it..
http://www.smallworkarounds.net/2009/07/sending-list-of-complex-objects-to-sql.html[^]

Please refer this article, and source code you will get your solution

XML File to SQL Database[^]

这篇关于如何从sql server 2008的.XML文件中检索数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！