Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Location
    Yangon,Myanmar
    Posts
    10

    Post Unanswered: May i know!. How can get XML report.

    I am programmer from Myanmar
    it is equal or not the Temporary database and XML file.
    Another one, is how can i generated XML query enginee .

    With Best regard!
    MR Tae Jay
    Myanmar.
    kongaung@gmail.com

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The "tempdb" database used by SQL Server is structured like any other database.

    There are many ways to generate XML from a SQL query. If you are using SQL 2005 or later, I'd recommend using the FOR XML clause of the SELECT statement. If you can use SQL Server Reporting Services, it is probably one of the easiest and most powerful ways to generate XML (or almost anything else) from data stored in SQL Server.

    -PatP

Posting Permissions

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