Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

sql 2005 xml searching

0 views
Skip to first unread message

nick chan

unread,
Apr 16, 2008, 1:14:08 AM4/16/08
to
hi i have a table with an XML column

this XML data looks like this

<details><attribute id="1" value="x"/><attribute id="2" value="y"/
><attribute id="3" value="z"/></details>


could anyone help guide me on how to search something like this?

-------
Select * from Table Where (XMLColumn contains attribute of id="2" and
value like "y%")

rote

unread,
Apr 16, 2008, 4:57:43 AM4/16/08
to
nick post it to the xml newsgroup and u will get a prompt reply

"nick chan" <zzzx...@gmail.com> wrote in message
news:ca4e2830-ae06-4b9c...@s13g2000prd.googlegroups.com...

nick chan

unread,
Apr 16, 2008, 6:22:38 AM4/16/08
to
thanks a lot !!

On Apr 16, 4:57 pm, "rote" <naijaco...@hotmail.com> wrote:
> nick post it to the xml newsgroup and u will get a prompt reply
>
> "nick chan" <zzzxtr...@gmail.com> wrote in message
0 new messages