How to add line breaks after each node when I use "for xml explicit"? I would appreciate it for any suggestions.
If you are using Query Analyzer with SQL Server 2000
executing "dbcc traceon(257)" will cause XML generated with
FOR XML to be displayed with line breaks.
|||
Mark,
Thank you so much! I feel I almost get there. I use dbcc traceon(257) and see the link breaks. I have a question to save the file?
I have sql script that return xml via "FOR XML EXPLICIT" clause. I can specify output to file in Query Analyzer. Is it possible to save output file as file extension .ctl? I would like to send you the file format to you if it could save your time and understand better for the file format I want. My email address is fancorning4@.yahoo.com
Thank you again
No comments:
Post a Comment