Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    15

    Unanswered: Generate XML from SQL 2000 tables

    Hi,

    I am a newbie to XML. I am trying to generate a customised format of XML document from SQL 2000 table. This document is something like an acknowledgment reply. Does it mean I have to create a table structure similar to the format of the XML document to facilitate the generation of the desired format?

    Any kind souls, please help.

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you look into

    FOR XML

    Operator?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Posts
    15
    In this case, am I correct to say I need to have a table structure that maps (which currently does not exist) to the hierarchy of the XML acknowledgement first. Pardon my ignorance. ;D
    ===================
    Originally posted by Brett Kaiser
    Did you look into

    FOR XML

    Operator?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Try this in QA

    Code:
    USE Northwind
    GO
    SELECT * FROM Orders FOR XML AUTO
    GO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •