XML export via BCP
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
For future reference: Exporting fully formatted XML with xsd or schema
headers.
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9336&FORUM_ID=5
The trick is the -c argument.
bcp "SELECT * FROM MyTable FOR XML RAW, XMLSCHEMA" queryout ztest.xml -
c -T
I'm posting this here as I spent the morning looking for this
solution, noticed other posters asking for same.
BOL wasn't helpful (who would've thought?) in clarifying the use of
the -c arg, without -c the output file becomes a big unicode mess.
/lee
.
Relevant Pages
- Re: Nebulous Re: British Chain Of Retail Shops Pulls "Lolita" Bed For Young Girls
... :>:clueless about reading or changing headers, ... :that I am ONLY posting from sci.military.naval, ... For the very good reason that it was in answer to a poster from scs. ... This is not the multi-group cross-posting to groups for no good reason that so many on both scs and smn have become embroiled in of late. ...
(sci.military.naval) - Waste of time?
... I've just wasted 3 minutes reading your question and posting a reply because you have not shared your embarrassing answer. ... I am struggling with getting a subdomain to work. ... response headers and the "Server" headers are different. ...
(microsoft.public.inetserver.iis) - Re: Conceal Identity
... using Outlook Express 6.0? ... Consider your posting headers: ... Your NNTP provider controls the rest. ...
(microsoft.public.windows.inetexplorer.ie6_outlookexpress) - Re: Nebulous Re: British Chain Of Retail Shops Pulls "Lolita" Bed For Young Girls
... If you call that cross-posting, ... If you leave a group in your headers then you are posting to that group. ... What I have been trying to get across is that, if you do not trim the headers, you may well be reading posts in one group and posting from within that group but your newsreader has you at home in one of the other groups you have in your headers. ...
(soc.culture.scottish) - Re: pattern for this dress?
... have been posting a loooooong time! ... headers by someone here and they were shopped to their ISP. ... before I learned that the headers contained information about my ISP. ...
(alt.sewing) |
|
