Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fastluver
Starting Member
1 Post |
 Posted - 2004-07-12 : 06:23:27
|
| Hi Dev'sI'm running a SQL query for generating result in XML. I use For XML Auto. the problem is the result is truncated by query analyzer and it returns the result half uncompleted. I urgently looking for a solution. any help is welcomed. Many tanx |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-07-12 : 07:14:19
|
| QA has a default limit of 256 characters per column returned....but you can amend this to a higher(unlimited) number...have a look at the 'options' for QA. |
 |
|
|
chacha
Starting Member
39 Posts |
Posted - 2004-07-12 : 11:47:00
|
| or just specify that the script should output to file, then read the file. If you have a big result tree you might want to just create a batch process that runs the sql, outputs to file, opens a perl/ruby/python/wscript file that parses the xml and reports on what it finds. Much easier (if you are going to use it again) than viewing the xml from the sql query analyzer. If I remember it plays havoc with newlines and other special characters. |
|
|
|
|
|
|
Sql Query Analyzer Truncates FOR XML AUTO results