beyondrelational.com

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery

This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples....

Posted: 07-01-2010 11:53 AM by Jacob Sebastian | with no comments

Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery, TSQL, SQLSERVER, BRH, XQuery Tutorials, XQuery Lab, XQuery Functions, xquery-lab, xquery labs, #XML, #XQUERY, #TSQL

XQuery Lab 61 – Writing a Recursive CTE to process an XML document

We have seen several examples of writing recursive queries in the earlier blog posts. For a quick recap, you can find some of those posts in the list given below. TSQL Lab 10 - Performing recursive updates in SQL Server TSQL Lab 11 - Writing a recursive...

Posted: 06-29-2010 7:02 PM by Jacob Sebastian | with 2 comment(s)

Filed under: XML, XQuery, BRH, xquery labs, #XML, #XQUERY, SQL Server - XQuery

XQuery Lab 60 – Executing dynamic query strings with OPENXML()

This installment of XQuery Lab shows how to execute dynamic queries that contain OPENXML() calls. We will see examples that use EXEC() and sp_executesql...

Posted: 06-24-2010 5:14 PM by Jacob Sebastian | with no comments

Filed under: XML, XQuery, BRH, xquery labs, #XML, #XQUERY, SQL Server - XQuery, #SQLSERVER

Using the XMLTable() Function

A few weeks back, I published a function named XMLTable() that helps to query XML documents easily. The idea behind the function is to be able to blindly query XML documents just like you do a ‘SELECT *’ on a relational table. Not only that this function...

Posted: 06-23-2010 2:23 PM by Jacob Sebastian | with no comments

Filed under: XML, XQuery, TSQL, SQLSERVER, SQLAuthority, #TSQL

XQuery Lab 59 – OPENXML() and XML Namespace Declarations

In the previous post , we saw a basic example that reads information from an XML document using OPENXML(). In this post, we will focus on reading information from XML documents having namespace declarations. Here is a simple example: DECLARE @x VARCHAR...

Posted: 06-22-2010 5:03 PM by Jacob Sebastian | with no comments

Filed under: XML, XQuery, BRH, xquery labs, #XML, #XQUERY, SQL Server - XQuery

XQuery Lab 57 – Getting Started with OPENXML

This post intends to help you get started with OPENXML() function. OPENXML() lets you shred an XML document or fragment into a result set. Though OPENXML() has got no direct relationship with XQuery, I thought of including it in the XQuery Labs series...

Posted: 06-17-2010 4:25 PM by Jacob Sebastian | with no comments

Filed under: XML, XQuery, TSQL, SQLSERVER, BRH, xquery labs, sp_xml_preparedocument, OPENXML, Database, DBA, #XML, #XQUERY, sp_xml_removedocument, #SQLSERVER

XQuery Lab 56 – Inserting elements with UNICODE values

This post explains how to write XML DML queries uisng XQuery in TSQL that deals with UNICODE character strings....

Posted: 06-09-2010 6:02 AM by Jacob Sebastian | with no comments

Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery, BRH, XQuery Tutorials, XQuery Lab, XQuery Functions

XQuery Lab 58 - SELECT * FROM XML

Most people find it very difficult to deal with XML documents in TSQL as there is no way to run a ‘blind’ SELECT * query on an XML document to get a quick view of the content stored in it. A “select TOP N *” query can quickly give you a few records from...

Posted: 05-30-2010 11:49 PM by Jacob Sebastian | with 5 comment(s)

Filed under: XQuery-Labs, XML, XQuery, BRH, XML Toolkit, XML Library, xquery labs

XQuery Lab 55 – Extracting values from XML elements that matches a string pattern

Here is another XQuery exercise that uses the contains() function to match a string pattern against an XML element and retrieves values from a sibling element. Here is the input data for this challenge. <ArrayOfCustomField> <CustomField> <Name>abc<...

Posted: 04-07-2010 9:48 AM by Jacob Sebastian | with 3 comment(s)

Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery

XQuery Lab 54 – Modifying an XML document with a SELECT Query

This post explains how to modify an XML document from a SELECT query in TSQL...

Posted: 03-31-2010 6:37 PM by Jacob Sebastian | with 2 comment(s)

Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery

XQuery Lab 53 – Reading information from SQL Server Extended Event Information XML

This installment of XQuery Labs explains how to read information from the XML document generated by SQL Server Extended Events....

Posted: 03-23-2010 6:42 PM by Jacob Sebastian | with no comments

Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery, TSQL, SQL SERVER, CROSS-APPLY

XQuery Lab 52 – A More Intuitive way of reading an RDF document

After reading XQuery Lab 51 , my friend and database expert Brad Schulz send me a note showing another way of achieving the same results. The approach he suggested was much cleaner than my version. My code used the following expression in the WHERE clause...

Posted: 02-25-2010 12:09 PM by Jacob Sebastian | with no comments

Filed under: XQuery-Labs, XML, XQuery, jacob, jacob_xml, XQuery Lab, xquery-lab

XQuery Lab 51 – Querying an RDF document using TSQL and XQuery

This installment of XQuery Labs presents a script that reads information from an RDF document using TSQL and XQuery....

Posted: 02-16-2010 3:36 PM by Jacob Sebastian | with 2 comment(s)

Filed under: XQuery-Labs, XML, XQuery, jacob, jacob_xml

XQuery Lab 50 – Reading data from Google Analytics Atom Feed

One of my friends emailed me this morning asking help for reading data from Google Analytics Atom feed, using Query with TSQL. My friend sent me a sample XML document he obtained from Google Analytics and here is the query that reads information from...

Posted: 12-23-2009 8:20 AM by Jacob Sebastian | with no comments

Filed under: XQuery-Functions, XQuery-Labs, XML, XQuery, jacob

XQuery Lab 49 – Deleting rows from a table based on the data in an XML document

We have seen a few examples that demonstrated how to delete elements and attributes from XML documents. In this lab, let us see how to delete rows from a table, based on the data in an XML document. DECLARE @t TABLE (id INT ) INSERT INTO @t(id) SELECT...

Posted: 08-26-2009 11:24 AM by Jacob Sebastian | with no comments