Hi All,
 I'm running a query such as [select * from table1 where OrderNumber = 123 for xml auto] and saving the results to an xml file (right
 clicking the
 "link" in the results pane that holds the info and saving as an XML
 file). The problem is, if I view the resulting file in notepad it
 looks like this:
 <test><OrderNumber>123<OrderNumber/><Name>Bob Smith</Name>
 <Add
 ress>456 Some Road</Address><State>CA</State><Zip>12345</Zip></test>
 The split <Address> element tag is causing all kinds of issues when I
 try
 to open the XML file. Did I just hit the right combination of length,
 elements, etc or am I missing something else here? This seems like a
 bug becasue it happens on some queries and not others.
 If I edit the element tag so it looks correct (<Address>456 Some Road</
 Address>) the XML file opens fine.
 Thanks in advance for any help.Actually I just noticed the same issue above in the third paragraph
where 'try' is the only word on the line. What is going on here?
 
No comments:
Post a Comment