Max output length 8192 for XML output 
Author Message
 Max output length 8192 for XML output
How do I get around the maximum column length (in Query Analyzer) of 8192
for outputting SQL selects with the FOR XML AUTO clause.  If the XML output
created a separate text row for each row, this wouldn't be an issue, but the
XML output is one long text string.  I've tried Isql to get around this, but
isql won't output XML because of Unicode issues.


Fri, 19 Nov 2004 01:44:42 GMT
 Max output length 8192 for XML output

8192 is fixed, however in QA execute

dbcc traceon(257)

then your FOR XML - you should see each element on a separate line

e.g.
dbcc traceon(257)
select * from authors for xml auto

However since SQLXML is essentially a client technology I tend
to have an asp page with an input at the top for a proc name or
sql statement which returns the xml to an iframe. This way I can see
all the output whilst testing and make sure its valid.

HTH
Jasper Smith


Quote:
> How do I get around the maximum column length (in Query Analyzer) of 8192
> for outputting SQL selects with the FOR XML AUTO clause.  If the XML
output
> created a separate text row for each row, this wouldn't be an issue, but
the
> XML output is one long text string.  I've tried Isql to get around this,
but
> isql won't output XML because of Unicode issues.



Fri, 19 Nov 2004 03:16:46 GMT
 Max output length 8192 for XML output

Thanks for the dbcc trace tip - I definitely split the lines in a human
readable format.  I still wish I could get around the 8192 limit but
this will do for now.  By the way - where are the dbcc trace flags
documented - the SQL books online is very vague.

Thanks again!

David Laub

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sat, 20 Nov 2004 04:42:03 GMT
 Max output length 8192 for XML output
Most of them are not -  a few are in KB articles
However a search on google usually turns up a good
selection and a few websites have various ones
I saw this one on sqlmag.com

HTH
Jasper Smith


Quote:

> Thanks for the dbcc trace tip - I definitely split the lines in a human
> readable format.  I still wish I could get around the 8192 limit but
> this will do for now.  By the way - where are the dbcc trace flags
> documented - the SQL books online is very vague.

> Thanks again!

> David Laub

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Sat, 20 Nov 2004 08:33:10 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. ADO output parameter max length

2. ADO output parameter max length

3. WISH- output extended proc results output to XML

4. XML templates: return SP OUTPUT parameter in XML

5. XML query node problem: same level root from output xml query

6. Word Wrapping XML output making invalid XML

7. output parameters and output recordsets

8. Handling SP output like a cursor select output.

9. Can not get output value for input/output parm

10. Capture sp output from other sp output

11. truncated output from sql server 7 using cold fusion to output

12. Output parameter vs Input/Output parameter


 
Powered by phpBB® Forum Software