Re: 8192 character limit in Query Analyser when returning data, how to save result without newline every 8192
From: Michael Rys [MSFT] (mrys_at_online.microsoft.com)
Date: 04/18/04
- Previous message: davidsanxter_at_vf.shawcable.net: "Little Sister Giving a Handjob"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 18 Apr 2004 00:07:42 -0700
You can write a small VB Script using ADO that will use the ADO result
stream to write the FOR XML result directly to a file.
I think some code may be available at http://www.sqlxml.org.
The Query Analyzer used ODBC, that had no streaming result support
(Workbench in Yukon will be better) and added the line-breaks about every
2033 characters.
HTH
Michael
"Niklas E" <raven_tln0sp4m@hotmail.com> wrote in message
news:OD44$SFJEHA.2424@TK2MSFTNGP12.phx.gbl...
> When I run a for xml query in query analyser, the result gets split up
> with
> line breaks if I save it to a file. How can I save the result without
> these
> line-breaks? I have 185000 line-breaks in my result and that is not easy
> to
> replace. Try to open a 785MB in a text-editor(=coffe-break). It is the
> result of a SP. Is there some way to save it directly to file, e.g. exec
> SP_MyXMLData > C:\big.xml
>
> Best regards
> Niklas
>
>
- Previous message: davidsanxter_at_vf.shawcable.net: "Little Sister Giving a Handjob"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
