Top "Xquery" questions

How can I query a value in SQL Server XML column

I have following XML stored in a XML column (called Roles) in a SQL Server database. <root> <…

sql sql-server xml xquery

Concatenate multiple node values in xpath

I have a XML that looks like this <element1> <element2> <element3> <element4>…

xml xslt xpath xquery spring-el

Is there a JSON equivalent of XQuery/XPath?

When searching for items in complex JSON arrays and hashes, like: [ { "id": 1, "name": "One", "objects": [ { "id": 1, "name": "Response 1", "objects": [ // etc. }] } ] …

javascript json xpath xquery

Using XPath, How do I select a node based on its text content and value of an attribute?

Given this XML: <DocText> <WithQuads> <Page pageNumber="3"> <Word> July <Quad> &…

xml xpath xquery

How to get a particular attribute from XML element in SQL Server

I have something like the following XML in a column of a table: <?xml version="1.0" encoding="utf-8"?> <…

sql-server xml xpath xquery

SQL: How can i get the value of an attribute in XML datatype

I have the following xml in my database: <email> <account language="en" ... /> </email> I'm …

sql xml sql-server-2008 tsql xquery

How to query xml column in tsql

I have a table, T1, with a XML column, EventXML, on SQL Server 2008. I want to query all the rows …

xml sql-server-2008 tsql xquery

how to use if else in xquery assignment

I am trying to use a if condition to assign a value to a variable in an xquery. I am …

xquery if-statement assignment-operator

SQL Server SELECT to JSON function

I would like to output the results of a SELECT statement as a JSON object. I would like this to …

sql xml json tsql xquery

how to select attribute value of a node in XQuery?

In below XML: <company> <customers> <customer cno="2222"> <cname>Charles</cname> &…

xml xquery