Solved

Read XML Document using TSQL in Query Analyzer

Posted on 2010-11-22
3
770 Views
Last Modified: 2012-05-10
Hi,

I have a table (Logs) with a column called Message of type XML.
Data is getting stored in this table using a web service (.Net) and they said, it is of type XML document (System.Xml.XmlDocument)

Is there any way to read the value (may be as a string)  through Query Analyzer?
0
Comment
Question by:batchakamal
3 Comments
 
LVL 19

Expert Comment

by:Bardobrave
ID: 34187726
If the xml document is stored as a string you can read it from the table with a simple select. Then you can load it to a xml editor and see it in a normalized way.

If System.Xml.XmlDocument is some type of byte-coded information wich encloses in one of their fields the xml itself, probably you'll only obtain a strange stream of byte data that you won't be able to understand from Query Analyzer.

However you could try to import that data into a project that's able to understood that data type and read it's xml through code.
0
 
LVL 6

Accepted Solution

by:
subhashpunia earned 500 total points
ID: 34195527
You can see the textual data stored in xml datatype column in query analyzer by quering the table using SELECT statement.
IN SQL Server 2005, if you want to see some specific values from then you can xml methods like query(), value(), exist() and nodes().
0
 
LVL 4

Author Closing Comment

by:batchakamal
ID: 34745087
dfdsfsd
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question