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

Content with tags XML, XQUERY Rss

   Items 1 to 10 of 10   

Extract the titles from XML

By Steve Jones 2015/07/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,508 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,769 reads

XML to Relational

By Stewart Campbell 2012/01/27 | Category: xquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,200 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,535 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,504 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,014 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,506 reads

XML XQuery problem

By Marcin Zawadzki 2009/03/12 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 3,332 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,323 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,745 reads
   Items 1 to 10 of 10   
t-sql (2)    
amo (1)    
bi (1)    
blogs (1)    
bulk insert (1)    
c# (1)    
cube (1)    
data dictionary (1)    
extended properties (1)    
for xml auto (1)    
integration services (ssis) (1)    
nodes() (1)    
openrowset bulk (1)    
openxml (1)    
string manipulation (1)    
xmla (1)