MS SQL XML - Specifiying xml directive with for xml explicit

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

Specifiying xml directive with for xml explicit

McGeeky

2005-07-13, 7:23 am

Is there a way to get for xml explicit to return an xml directive too?

I want this to be output before the xml:

<?xml version="1.0" encoding="ISO-8859-1"?>

--
McGeeky
http://mcgeeky.blogspot.com

Michael Rys [MSFT]

2005-07-14, 3:23 am

No. The XML declaration cannot be generated using FOR XML EXPLICIT. You
should be able to set the output encoding on the ADO command property for
example.

Best regards
Michael

"McGeeky" <anon@anon.com> wrote in message
news:eWez3F5hFHA.3288@TK2MSFTNGP09.phx.gbl...
> Is there a way to get for xml explicit to return an xml directive too?
>
> I want this to be output before the xml:
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
>

Sponsored Links