Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag XQUERY Rss

   Items 1 to 12 of 12   
 

Fastest way to split delimited string in SQL Server

Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.  Read more...
By Kshitij Satpute 2013/08/14 | Source: SQLServerCentral.com | Category: split string
Rating: |  Discuss |   Briefcase | 2,236 reads

TSQL- XQuery

By pramod singla 2013/07/29 | Category: xquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,115 reads

XQuery string functions

By Seth Delconte 2012/06/07 | Category: xquery
Rating: (not yet rated) |  Discuss |   Briefcase | 1,943 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: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 10,151 reads

XML to Relational

By Stewart Campbell 2012/01/27 | Category: xquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,149 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: SQLServerCentral.com | Category: bi
Rating: |  Discuss |   Briefcase | 5,330 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: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,147 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: SQLServerCentral.com | Category: xquery
Rating: |  Discuss |   Briefcase | 11,933 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,379 reads

XML XQuery problem

By Marcin Zawadzki 2009/03/12 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 3,294 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,180 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: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 6,671 reads
   Items 1 to 12 of 12   
 
Tags
xml (9)    
t-sql (3)    
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)    
openrowset bulk (1)    
openxml (1)    
r-bar (1)    
split delimited string. (1)    
split string (1)    
sql server (1)    
string function (1)    
string manipulation (1)    
xmla (1)