Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag XQUERY Rss

Search for any content tagged xquery

   Items 1 to 8 of 8   

A Possible Alternative to SQL UNPIVOT

Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.  Read more...
By Paul Milligan 2017/01/16 | Source: | Category: pivot
Rating: |  Discuss |   Briefcase | 1,994 reads

Basics of XML and SQL Server, Part 2: Shredding XML

In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.  Read more...
By Stan Kulp 2012/03/14 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 10,817 reads

Managing Data Dictionaries in DW and DSS Database Applications

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.  Read more...
By Frank A. Banin 2011/12/20 | Source: | Category: bi
Rating: |  Discuss |   Briefcase | 5,547 reads

XQuery for the Non-Expert – @Variable Use

Talk to the Experts In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert...  Read more...
By StrateSQL 2011/01/20 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,595 reads

XML Workshop 26 – SELECT * FROM XML

This article presents a generic function that makes it easy to query XML documents  Read more...
By Jacob Sebastian 2010/06/30 | Source: | Category: xquery
Rating: |  Discuss |   Briefcase | 12,027 reads

Ten Problems with XQuery and the SQL/XML Standard

XQuery and SQL/XML standard are processors for XML. SQL/XML was designed to try to match the capabilities of XQuery as closely as possible and XQuery was designed not only to support XML, but also to support relational processing. Read on to learn why this may have a negative influence on their capabilities.  Read more...
By Additional Articles 2010/03/02 | Source: Database Journal | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,543 reads

Introduction to XQuery in SQL Server 2005

This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features.  Read more...
By Additional Articles 2008/06/20 | Source: TechNet Blogs | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 3,374 reads

XML Workshop XII - Parsing a delimited string

Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.  Read more...
By Jacob Sebastian 2007/12/05 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 6,748 reads
   Items 1 to 8 of 8