Blog Stats
  • Posts - 24
  • Articles - 0
  • Comments - 71
  • Trackbacks - 91

 

<< 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

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

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
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

 

 

Copyright © Eron Wright