MS SQL XML - truncating output from FOR XML EXPLICIT

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

truncating output from FOR XML EXPLICIT

prefersgolfing

2005-12-09, 8:25 pm

It appears somthing is causing my output to truncate in the Query Analyzer.
It truncates in the middle of a tag name and continues the output on the
next row. Any ideas? The length is 2033.

prefersgolfing

2005-12-12, 11:23 am

I found the solution at:
http://www.aspnetresources.com/blog.../> tes_xml.aspx
"prefersgolfing" < prefersgolfing@hotma
il.com> wrote in message
news:%23LdpBpP$FHA.916@TK2MSFTNGP10.phx.gbl...
> It appears somthing is causing my output to truncate in the Query
> Analyzer. It truncates in the middle of a tag name and continues the
> output on the next row. Any ideas? The length is 2033.
>

Sponsored Links