 - XQuery is a specification for a query language that allows a user or programmer to extract information from an Extensible Markup Language (XML) file or any collection of data that can be XML-like. The syntax is intended to be easy to understand and use. Using XQuery, it is possible to view a relational database table as an XML document. XQuery is an evolving specification under development by the World Wide Web Consortium (W3C) and has broad support from several major vendors including IBM, Microsoft, and Oracle.
XQuery makes use of XPath, a language that describes a way to locate and process items in XML documents. The specifications of XPath and XQuery are closely related. XQuery 1.0 derives directly from XPath 2.0. In XQuery, XPath expressions can be simple queries or parts of larger queries. XQuery has functions for numerous operations including date and time comparisons, mathematical calculations, string manipulations, and Boolean algebra. If a particular function is needed and is not found in XQuery, the programmer can write one.
 |
Learn more about XML in SQL Server |
| XML data type in SQL Server 2005 vs. VARCHAR (MAX): Learn performance impacts of the XML data type and VARCHAR (MAX) data type in SQL Server 2005. Here are storage, I/O and CPU results of XML in SQL Server. |
| T-SQL commands vs. XML AUTO in SQL Server: XML functions may use more resources than standard T-SQL commands. Here are some performance implications when comparing XML AUTO with T-SQL commands. |
| Difficulty storing XML data in SQL Server 2005: Should I store all of my XML data in SQL Server 2005 using the new XML data type? |
| XML integration with SQL Server 2005 chapter download: This chapter from the book "Microsoft SQL Server 2005 New Features," by Michael Otey, serves an introduction to the most important new XML features provided by SQL Server 2005. |
| SQL Server 2005 Learning Guide: Are you ready for SQL Server 2005? Here you will find news and expert technical advice to answer your SQL Server 2005 questions and put you on track for a successful upgrade. |
| Top 10 SQL Server development tips of 2008: From converting date/time values into character types to retrieving XML data values with XQuery, these were the top 10 SQL Server development topics of 2008. |
| Problems and justified use of cursors: Cursors should traditionally be avoided, however, this book excerpt outlines situations in which cursors are acceptable in T-SQL. |
| Cursor related statements: This book excerpt illustrates cursor statements, including the open statement, fetch statement, @@fetch_status, close statement and the deallocate statement for T-SQL cursors. |
| Transact SQL cursors: The following excerpt outlines how to process a cursor for Transact-SQL Server. You'll also find an example of how cursors are used to repeat custom processing. |
| Unconditional and scheduled execution: This book excerpt explains unconditional execution and scheduled execution for flow control statements in T-SQL. |
| CONTRIBUTORS: |
Jelle Kooi |
| LAST UPDATED: |
01 Apr 2005
|
 |
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com
|
|
More resources from around the web:
|
|
Show me everything on 
