Questions tagged [xquery-sql]

the XQuery language as supported by database systems. Include the tag of your system to specify ("sql-server", "oracle", "postgresql", etcetera). Use the "xquery" tag on its own for general questions about XQuery.

XQuery is a query language designed to extract data from arbitrary XML documents. Multiple RDBMSes support XQuery as part of the SQL/XML standard or using proprietary syntax. What follows is a non-exhaustive list.

Microsoft SQL Server

In SQL Server 2005 and onwards, the xml data type methods, in particular .query(), support querying XML and returning the results as relational data. These methods support a subset of XQuery, with special support for some T-SQL specific constructs like variables -- see the XQuery Language Reference for specifics.

Oracle

Oracle includes XML support as Oracle XML DB. It supports XQuery both for querying and updating data, both relational and XML. The XMLQUERY function is used to issue XQuery queries within an SQL statement.

453 questions
-3
votes
1 answer

Recursivity XML SQL OPENXML

I can't found how to do that... I want to get the properties "fullName" and "passed" of all test-suite and test-case of this XML code. This XML returns the result of unit tests. I want to store them in a simple table with columns: FullName,…
Alex Spitz
  • 85
  • 7
-4
votes
1 answer

T-SQL get value from XML

I am trying to query XML (SSRS) in SQL Server; I want to get the value from the TO in this case. TO PacoAT@Stack.com
user13520940
  • 133
  • 2
  • 7
1 2 3
30
31