For XML data retrieval

fancorning4 · May 17th, 2006, 03:18 PM

How to add line breaks after each node when I use "for XML explicit"? I would appreciate it for any suggestions.

David_the_DBA · May 18th, 2006, 07:59 AM

What are you using to view the data afterwards. If you were saving the XML out as a .XML file and then viewing it in Internet Explorer, or a real XML tool, then it will do the formating for you. If you are just looking at the result in Query Analyzer I don't know what to tell you.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

fancorning4 · May 18th, 2006, 10:33 AM

David,

Thank you so much! I got the link breaks in the result in Query Analyzer by using use dbcc traceon(257). Is it possible to save the file as .ctl? .In the file with extension .xml, the line break is just like â â without quotations. In the file with extension .ctl, the line break is like â[] â without quotations.

I want to save file as .ctl in order it has right line break for the file with extension .ctl.

Thank you in advance

Fan