Top "Xquery" questions

Parse XML using T-SQL and XQUERY - Searching for specific values

I have some properties of an application being passed to me in XML form. I need to parse out the …

sql-server sql-server-2008 tsql xpath xquery

XQuery: Return value of an element rather the element itself

I have an XML document that contains the following ... <foo>abc</foo> ... If I evaluate return $…

xml xquery

Difference between XPath, XQuery and XPointer

What is the difference between XPath, XQuery and XPointer? As far as I know, XQuery is an extended version of …

xml xpath xquery

XQuery order by ascending and descending

In XQuery, How do you order by ascending and descending? I have got the following from a tutorial: for $x …

xml xquery

How to concatenate all strings from a certain column for each group

Suppose I have this table [Table1] Name Mark ------- ------ ABC 10 DEF 10 GHI 10 JKL 20 MNO 20 PQR 30 What should be my …

sql sql-server tsql xquery sql-server-group-concat

XML query() works, value() requires singleton found xdt:untypedAtomic

I have a typed xml document stored as text. So I use CONVERT the data type to xml by using …

sql sql-server sql-server-2005 tsql xquery

Use of xml.modify to insert parameters into specific element of an xml column

I would like to use a stored procedure to insert some values passed in as parameters into elements in the …

sql xml sql-server-2008 tsql xquery

Getting multiple records from xml column with value() in SQL Server

This SQL only returns the first Activity element. How do I select them all? If I remove the [1] in the …

sql-server-2005 xquery

Simple tool to learn XQuery?

I started playing around with XQuery. On [w3schools][1] its a good tutorial. I just have some problems: I cannot …

xml xquery

Return multiple values from multiple inputs in XQuery 3.0?

I've tried a few things: for $name in ('Hanz', 'Heinz', 'Hans', 'Huns', 'Hund') where $name contains text 'Hans' using fuzzy …

xml xquery xquery-3.0