Topic: Result of performance of stored procedure SQL in a XML file
I have a stored procedure, approximately such type:
SELECT 0.1 as "@version";
FOR XML PATH ("), TYPE, ELEMENTS
) AS MessageHeader,
FOR XML PATH ("), TYPE, ELEMENTS) AS DeliveryNote
FOR XML PATH (' BLRWBL ')
I.e. on an output I receive a XML file with the groupings necessary to me.
Question in that it is necessary to write down given results in a xml-file not SQL server means, and stored procedure means (to set in parameter). Still it is necessary to add type title <? xml version = "1.0" encoding = "UTF-8"?>.