MS SQL Server, Max output length 8192 for XML output

Max output length 8192 for XML output

Author	Message
David Lau #1 / 4	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

Jasper Smit #2 / 4	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

David Lau #3 / 4	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

Jasper Smit #4 / 4	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

Page 1 of 1

[ 4 post ]