Post reply

How to get stored procedure out put to xml in sql server 2005

  • April 16, 2009 at 8:20 am

    #155565

    Hi All,

    I have written a stored procedure with two parameters in which I have declared some temporary tables and in the main select statement I am doing some calculations and giving user friendly column name.

    Now I have to export the output of stored procedure to XML

    so for this I am using 'FOR XML RAW' or 'FOR XML AUTO'

    Now when I am executing the stored procedure it is giving wrong and incomplete XML output

    So please tell me where I am wrong and what is the right way to get out put in XML

  • April 16, 2009 at 8:24 am

    #978895

    Hi

    Could you please paste the code of your stored procedure and how are you calling that.

    Thanks -- Vijaya Kadiyala
    www.dotnetvj.com
    SQL Server Articles For Beginers


  • April 16, 2009 at 10:11 am

    #979001

    Hi

    If the FOR XML AUTO fits your requirements you can simply add the name for the root element to be created:

    FOR XML AUTO, ROOT('root')

    Greets

    Flo

  • April 17, 2009 at 2:14 am

    #979466

    Hi All,

    Thanks for your kind suggestions. I was doing right but the XML output which I was copy and pasting on notepad was wrong axction because it was not copying whole XML output.

    But when I was clicking on the XML output it is opening in new query analyzer with whole XML output.

    So I got my XML out put.

    Again Thanks friends.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply