August 6, 2008 at 4:14 am
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.
August 6, 2008 at 8:01 am
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?
August 6, 2008 at 8:21 am
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