Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:
XML
<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.
Posted
Updated 20-Aug-18 0:12am
Comments
ArunRajendra 5-Aug-13 3:14am    
Do you mean the it fails after putting 97k records in xml it fails? How are you doing it in stored procedure?

 
Share this answer
 
v2
Comments
Raja Sekhar S 5-Aug-13 3:27am    
Nice Links..
+5!
ridoy 5-Aug-13 3:31am    
Thanks Raja.
Please refer this article, and source code you will get your solution

XML File to SQL Database[^]
 
Share this answer
 
Comments
Jochen Arndt 20-Aug-18 7:03am    
Please don't resurrect old questions to just provide a link to one of your articles.

If the question popped up on the list again for some reason, you probably did not checked the date.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900