Blog Stats
  • Posts - 24
  • Articles - 0
  • Comments - 65
  • Trackbacks - 92

 

<< UTC datetime values in SQL Server 2000 | Home | C#: Properties versus getter methods >>

Working with Query Analyzer and FOR XML

If you work with SQL Server 2000 and FOR XML functionality, you curse Query Analyzer probably as often as I do.  Here are some tips for improving the output:

  1. In QA, set “Maximum Characters per Column” setting to 2033
  2. Execute DBCC TRACEON(257) to pretty-print the XML output

http://www.winnetmag.com/SQLServer/Article/ArticleID/20698/20698.html

Print posted @ Wednesday, September 15, 2004 2:40 PM

Feedback

# re: Working with Query Analyzer and FOR XML

Gravatar why only 2033 and not the max of 8192? 9/17/2004 11:57 AM | Colin Bendell

# re: Working with Query Analyzer and FOR XML

Gravatar I guess I should have said "at least 2033". 9/17/2004 12:07 PM | Eron Wright

# re: Working with Query Analyzer and FOR XML

Gravatar hey, that was very simple and extremely helpful!!

thanks!

12/8/2004 8:55 AM | Matheus Guimaraes

# re: Working with Query Analyzer and FOR XML

Gravatar It was a very nice idea! Just wanna say thank you for the information you have shared. Just continue writing this kind of post. I will be your loyal reader. 10/19/2009 10:10 PM | tiffany key ring
Post a comment





 

 

 

Copyright © Eron Wright