I created a Select statement using the For XML Explicit clause to convert SQL data into an XML format. As you are aware the XML declaration statement -- <?xml version ="1.0" encoding="UTF-8"?> must be inserted before defining the root element.
How do I define the XML declaration statement with respect to my existing Select...For XML Explicit statement?
How do I define the XML declaration statement with respect to my existing Select...For XML Explicit statement?