May 23, 2011 at 2:40 pm
Hi,
I have a table Proclarity_PAS with column XMLData of datatype ntext. I want to extract and read the XML content in the column. In query Analyzer I cannot see the full xml.
Please let me know how I can accomplish this. Please let me know if you need more information.
Thanks and Regards,
Praveena.
May 23, 2011 at 3:47 pm
Query Analyzer only returns the first 256 characters of a column by default. You can increase it to a maximum of 8192 in:
Tools > Options > Results Tab
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 7:53 pm
you might also want to convert it to XML, then you can actually expand it and look at the elements (it'll come back as a link, click on it, and it'll open in a new connection)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 24, 2011 at 3:04 pm
@opc.three: Thank you! It helped.
I have other question though. I want to read the string between <MDX> and </MDX> tags. How can I do that? I am very new to XML. I am using SQL 2000.
Thanks and Regards,
Praveena
May 24, 2011 at 3:28 pm
venus.pvr (5/24/2011)
@opc.three: Thank you! It helped.
You're welcome!
I have other question though. I want to read the string between <MDX> and </MDX> tags. How can I do that? I am very new to XML. I am using SQL 2000.
I appreciate that you are just starting out and this forum site is a great place to start.
Unfortunately I do not have an instance of SQL 2000 that I can use to create working/tested code for you...sorry I only have SQL 2005 & SQL 2008 available. I still have the 2000 client tools installed however so I was able to help you with your original question.
As a rule it's better to start a new thread for new questions rather than carry on after an existing question has been answered. Please post a new topic to the XML forum with DDL to create tables, DML to create sample data and your expected results. I am certain you will quickly get high-quality assistance if you post a question complete with those items. Here is an article to guide you in creating your initial post:
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply