Solved

XML Character length

Posted on 2011-03-04
5
385 Views
Last Modified: 2012-05-11
In SQL Server I know that varchar(max) is @8000 characters.

What is the max for XML output?

And is there a link that shows me all character type max lengths?
0
Comment
Question by:lrbrister
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
ID: 35036120
http://msdn.microsoft.com/en-us/library/ms187752.aspx

You'll have to click each type to get more info.

XML can hold up to 2GB.

0
 
LVL 10

Expert Comment

by:Umar Topia
ID: 35036162
Please refer this lnk:-
http://stackoverflow.com/questions/2742651/xml-output-is-truncated-in-sql

It has suggeted that, your Management Studio will truncate the XML once it crosses 2MB, but if you use it from C# code, you should be able to get the bigger XML data without truncation
0
 

Author Comment

by:lrbrister
ID: 35036230
Hey guys...and the select statement in SQL?
0
 

Author Comment

by:lrbrister
ID: 35036241
Hey guys...sorry about the question...wrong thread.
0
 

Author Closing Comment

by:lrbrister
ID: 35036243
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IF SQL Query 12 27
Linked Server - SP with Param to VIew 7 21
SQL - Error "The Multi-Part Identifier could not be found" 2 16
SQL query 7 12
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question