Processing XML files with SQL Server functions

5 pts.
Tags:
SQL Server
SQL Server 2005
SQL Server Functions
XML
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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).

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: