Click here to Skip to main content
14,174,399 members
Rate this:
 
Please Sign up or sign in to vote.
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:
<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?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

   
v2
Comments
Raja Sekhar S 5-Aug-13 3:27am
   
Nice Links..
+5!
ridoy 5-Aug-13 3:31am
   
Thanks Raja.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

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

XML File to SQL Database[^]
   
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.190524.3 | Last Updated 20 Aug 2018
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100