Hello, I am trying to export to xml file using bcp command with queryout and select... FOR XML PATH
option.
I have a test data of 5000 records.
Expected output is:
<row>
<column1><\column1>
<column2><\column2>
<\row> *line break here*
<row>
<column1><\column1>
<column2><\column2>
<\row> *line break here*
However, bcp doesn't recognize a row/record from the queryout + for xml
. So I think the -t or -r delimiter option from bcp doesn't work.
I want bcp to recognize the 5000 records thru -r delimiter option. Can you please help me solve this?
Thank you