bcp to xml

[Matthew Butler]

can someone please advise me on the correct syntax to bcp export executing a
stored procedures results to xml

I know it begins

bcp "exe sp_procedure" queryout

but unser on the rest of the syntax

many thanks

[Andrea Montanari]

hi,

Post by Matthew Butler
can someone please advise me on the correct syntax to bcp export
executing a stored procedures results to xml
I know it begins
bcp "exe sp_procedure" queryout
but unser on the rest of the syntax
many thanks

please have a look at the very bottom of the page
http://www.perfectxml.com/articles/XML/ExportSQLXML.asp

regards