How to convert data into xml

[jaisi]

using sql query analyzer how data can be converted into xml format;

Tried using for xml clause but some of the records are missing

[Purple]

Hi jaisi and welcome to TSDN MSSQL forum,

Can you elaborate on which records are missing, can you post the query you have used..

Regards Purple

[jaisi]

Hi jaisi and welcome to TSDN MSSQL forum,

Can you elaborate on which records are missing, can you post the query you have used..

Regards Purple

Hi,

If i give the below query[Select * From tablename
For xml auto ,elements]

the output iam getting is not a complete XML document but a XML fragment containing an element for each row returned by the query!!is it possible to create a well-formed XML Document by adding the root element as a wrapper around it?