Re: Querying xml data with SQL
- From: markc600@xxxxxxxxxxx
- Date: 18 Jan 2007 08:39:38 -0800
You need an exist 'clause'
WHERE xmlData.exist('//*/child[./text()="idA" or ./text()="idB"]') = 1
.
- Follow-Ups:
- Re: Querying xml data with SQL
- From: Cathy
- Re: Querying xml data with SQL
- References:
- Querying xml data with SQL
- From: Cathy
- Re: Querying xml data with SQL
- From: Denis Ruckebusch [MSFT]
- Re: Querying xml data with SQL
- From: Cathy
- Querying xml data with SQL
- Prev by Date: Get XML On Its Merry Way
- Next by Date: relationship between xml in xml data type column
- Previous by thread: Re: Querying xml data with SQL
- Next by thread: Re: Querying xml data with SQL
- Index(es):
Loading
