Re: Select with a Where that looks up in a XML column... Possible?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Thu, 10 May 2007 18:08:02 -0400, ThunderMusic wrote:

(snip)
Is it possible? if so, how?

Hi ThunderMusic,

Yes, I think that this is possible, using XQuery to query the XML data
in the XML column. However, the only thing I know of XQuery is that it
exists :-)

You should repost your question in microsoft.public.sqlserver.xml,
preferably with some sample data and expected results. You'll probably
find some XQuery expert to help you there.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.

Relevant Pages

  • Re: XQuery vs OpenRowset
    ... OpenRowSet in SQL Server 2005. ... I'm by no means an expert on XML, but I would say that XQuery is ... Of course, if all you want to do is to unpack an XML document, using ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • RE: Query xml field in Query Plan DMV
    ... You could query the XML column in the DMV as any other XML column in SQL by ... For more detailed information about how to query the XML date using XQuery, ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.xml)
  • Re: lower-case() Function in XQuery
    ... At the moment I am nearly desperate in using all those things like XPath, ... XQuery and so on in SQL Server. ...
    (microsoft.public.sqlserver.xml)
  • Re: Need help with xquery order
    ... Order by does require a singleton or empty sequence, and the SQL Server 2005 ... XQuery processor has static type checking. ... The reason why your "where" clause works because XQuery contains two types ...
    (microsoft.public.sqlserver.xml)
  • Re: search within single xml document in SQL 2005
    ... Search on belief using the full-text contains predicate. ... Looking for a SQL Server replication book? ... I have a full text indexed xml column in sql server 2005 containing the ... Could anyone give me pointers as to how to implement this in XQuery / ...
    (microsoft.public.sqlserver.fulltext)