1

Topic: To transfer results of performance of stored procedure to a XML file.

There is a stored procedure in basis on a SQL server. It forms the data in a type xml with all groupings necessary to me (FOR XML). It is necessary means sql (for example, from other stored procedure) to write down these results in a xml-file and to add in it title "<? xml version =" 1.0"encoding ="UTF-8"?>". I so understood for this purpose utility BCP serves but how to write down about its help results of performance of stored procedure and did not understand. And still a problem that at such title Russian letters "are lost".

2

Re: To transfer results of performance of stored procedure to a XML file.

Hello, Bob, you wrote: Bob> It is necessary means sql (for example, from other stored procedure) to write down these results in a xml-file and to add in it title "<? xml version =" 1.0"encoding ="UTF-8"?>". The title should not be added"- it displays what  is applied to a XML-content, and  curve title only misleads a parcer. XML is not the text, it is a byte stream which can is frequent to look similar to the text. Bob> and still a problem that at such title Russian letters"are lost". Are lost - in sense, are incorrectly shown? Or simply disappear from an output?