Ho i see XML data OUT PUT in SQL server 2005

  • Hi GURUZ,

    I have successfully import XML data into SQL server 2005, now problem is I want to see this data as a graphical out put how this is possible .

    Thanks in advance.

    Best Regards
    Faheem latif
    Senior Database Architect
    Genie Technologies (Pvt.) Ltd.

  • Explain what you mean by graphical output?

    Also need to know how is the data stored? As string text, as binary, as xml data type?

    Have you looked at the FOR XML keywords in BOL for returing XML data?

  • Assuming you just mean you want to see the data in a logical manner......

    If you select the column with the XML data (assuming it is in an XML data type column, if not convert it on select), get the result in a grid format. Then you can click on the xml link it creates and it brings it up in a better format.

    I have also found the XML Notepad from Microsoft is great for a quick look at XML data.

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

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