MS SQL XML - FOR XML EXPLICIT - capture the output

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

FOR XML EXPLICIT - capture the output

Bruce Baker

2006-11-21, 12:21 am

Hi

I'm moving my code from vb6 to vb.net 2005

We have a few procs which return XML fragments via 'FOR XML EXPLICIT'

I just want to write the output to a file which I'll be throwing in a few
more xml fragments - how do I do write to this file with the output from the
stored proc ?

Thanks
Bruce

Emil

2006-11-21, 5:26 am

Hi Bruce,

Maybe the code example "Exporting data to a XML file in SQL Server
2005" [1] is helpful for you.

Regards,

Emil

[1] http://www.sqldbatips.com/showarticle.asp?ID=23

Sponsored Links