Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

XML Column Advice for XML Newbie

 
   Database Help (Home) -> XML RSS
Next:  SQL 2005 replication /w updatable subscriber  
Author Message
tigriswoods

External


Since: Oct 17, 2008
Posts: 1



(Msg. 1) Posted: Fri Oct 17, 2008 4:17 am
Post subject: XML Column Advice for XML Newbie
Archived from groups: microsoft>public>sqlserver>xml (more info?)

Hello,

I am new to formal XML and the new XML columns in Sql Server 2005. I have
done some reading on it and have tried to create what I thought was a simple
case but I am struggling to access and modify the data. Basically I need
some help implementing my first xml column please. Here's a sample of what I
would like to store:

<Recommendations>
<Recommendation type="standard">Treatment Required</Recommendation>
<Recommendation type="standard">Therapy Advised</Recommendation>
<Recommendation type="freeform">Test for Diabetes</Recommendation>
</Recommendations>

This is a list of multiple recommendations elements, which have a
Recommendation type attribute, and a value which is the text of the actual
recommendation.
I'd like to be able to query for elements that have an attribute value of
"Freeform".
I'd also like to be able to query for elements that have a value of
"Treatment Required".
I'd like to be able to add (and remove) Recommendations.
I'd like to be able to retrieve these values into an ASP checkboxlist
(array) and also into an ASP bulleted list.

Should be easy, right......? Aaaugh!! Half of my hair is ripped out right
now. So let me start back at the beginning and ask some questions.

1. I'd like to use a schema collection. What should it look like?
2. How should I set the xml column attribute "Is XML Document"

Thanks in advance!

 >> Stay informed about: XML Column Advice for XML Newbie 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
xquery question: Sample from MSDN2 not working, need advice. - From this page http://msdn2.microsoft.com/en-us/library/ms345117.aspx# The example for "Rich Language Constructs in XQuery" returns the follwoing error: "Msg 2209, Level 16, State 1, Line 2 XQuery [docs.xCol.query()]: Syntax error near '...

Newbie - generate XML tree from parent-child hierarchy - Hi all, I'm trying to do something that I know should be straightforward, but I just cannot get it to work. Imagine a simple Bill-Of-Materials with one table and a parent-child relationship. e.g. PartNumberID, ParentPartNumberID, PartDescription,..

newbie to xpath/xquery trying to pull email address out of.. - i'm trying to pull out email addresses info from the SSRS subscription table. The xml looks like this: <ParameterValues> <ParameterValue> <Name>TO</Name> <Value>pep1@myemail.com;pep2@myemail.com</Value> </Pa...

Can't see Element in the Output Column - Hi , I have a peculier problem. I am having a requirement to Load XML file into database in the normalized form. When I am using following XSD for loading data. In the SSIS XML Source Editor -> Columns, I am unable to see folloing columns. These..

xml column(s) and performance - What is better to have in a table from performance point of view: (a) all data combined in single xml column (b) several xml coulmns where data is spread logically Thank you, Volodia
   Database Help (Home) -> XML All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]