Tags » XQuery

XQuery - A FLWOR Example

I don’t often get the chance to use XQuery in my daily routine, but when I do, I like to place code snippets on this blog so that I or anyone else can make use of it in the future. 92 more words

SQL Server

Parsing sibling repeating XML groups : Part 2

This post is an addendum to a previously published How-To presenting various techniques to break sibling repeating groups into relational data :

… 1,220 more words

Execute SQL query from OSB 11g Xquery file


below snap shot of code is just for reference. I recently had a requirement where I had to execute a SQL query in XQuery file and same should be returning some result. 108 more words


Transact SQL - XQuery - Error - "XQuery [query()]: Attribute may not appear outside of an element"


Stole one of┬áBob Beauchemin’s Code and had to understand it.

  1. Author :- Bob Beauchemin
  2. Topic :- Move over developers! SQL Server XQuery is actually a DBA tool…
  3. 878 more words

How To : Generate Empty XML Attributes

It is well-known that XML attributes may be generated using SQL/XML publishing function XMLAttributes().
It is also well-known that XMLAttributes() does not generate anything when passed an expression that evaluates to NULL : … 907 more words