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:

Want data to be stored in single variable.
Updated 20-Aug-18 0:12am
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
Please Sign up or sign in to vote.

Solution 1

Raja Sekhar S 5-Aug-13 3:27am
Nice Links..
ridoy 5-Aug-13 3:31am
Thanks Raja.
Rate this: bad
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[^]
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