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 :

<root>
  <id>1</id>
  <name>SMITH</name>
  <id>2</id>
  <name>WILSON</name>
  <id>3</id>
  <name>GRANT</name>
</root>
… 1,220 more words
SQL

Execute SQL query from OSB 11g Xquery file

Hello,

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

OSB

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

Background

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
Microsoft

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

HowTo