Home > IT Answers > SQL Server > Processing XML files with SQL Server functions
HughFox10
5 pts.
 Processing XML files with SQL Server functions
SQL Server 2005, SQL SERVER 2005 XML, SQL Server Functions, XML, XML Files in SQL Server 2005
Hi I read through your tip on Processing XML files with SQL Server functions. It's great but what happens when the XML file exceeds 4000 charcters? I'm using SQL Server 2005 and the XML file that I try and import is too big. Do you have any ideas to how I can use SQL to import an XML file that exceeds the 4000 character? Your input would be greatly appreciated.

Software/Hardware used:
ASKED: March 2, 2009  1:43 PM
UPDATED: March 2, 2009  4:53 PM
RELATED QUESTIONS
Answer Wiki:
The XML data type that I used in the article supports up to 2 Gigs of data (~1 billion characters as XML is uni-code).
Last Wiki Answer Submitted:  March 2, 2009  4:53 pm  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _