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

 

Wednesday, September 15, 2004

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

 

 

Copyright © Eron Wright