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

Content with tag OpenXML Rss

   Items 1 to 13 of 13   
 

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 | 9,987 reads

OPEN XML Join

This is an example of joining two group nodes using openxml.. In case you have an xml field in the database that you may query  Read more...
By William Mendoza 2011/02/04 | Source: SQLServerCentral.com | Category: openxml
Rating: |  Discuss |   Briefcase | 925 reads

OPENXML

By VM-723206 2009/06/02 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,842 reads

Using OpenXML

SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a little confusing. SQL Server 2005 will add many more features and functions, but in the meantime, if you are looking to add some XML support to your 2000 server, new author Raj Vasant brings us some basics on using OpenXML.   Read more...
By Vasant Raj 2007/02/23 (first published: 2005/05/12) | Source: SQLServerCentral.com | Category: openxml
Rating: |  Discuss |   Briefcase | 38,265 reads

Turn XML into relational data with OPENXML

XML support has been significantly extended for SQL Server 2005. In this article, Tim Chapman takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.  Read more...
By Additional Articles 2007/02/22 | Source: Builder.com | Category: openxml
Rating:  Rate this |   Briefcase | 4,397 reads

Shred XML data with XQuery in SQL Server 2005

Tim Chapman discusses new functionality in SQL Server 2005 that allows you to shred XML data into a relational format without the intensive memory operations. He also explains how using XQuery rather than OPENQUERY can lead to performance gains.  Read more...
By Additional Articles 2007/02/20 | Source: Builder.com | Category: openxml
Rating:  Rate this |   Briefcase | 3,465 reads

Using OpenXML Part II

XML is becoming more and more prevalent in applications and more SQL Server DBAs are learning to work with this data structure. Raj Vasant brings us part 2 of his series on using OPENXML inside SQL Server, looking at passing XML into your stored procedures this time.   Read more...
By Vasant Raj 2006/02/16 | Source: SQLServerCentral.com | Category: openxml
Rating: |  Discuss |   Briefcase | 8,322 reads

Using OpenXML

SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a little confusing. SQL Server 2005 will add many more features and functions, but in the meantime, if you are looking to add some XML support to your 2000 server, new author Raj Vasant brings us some basics on using OpenXML.   Read more...
By Vasant Raj 2007/02/23 (first published: 2005/05/12) | Source: SQLServerCentral.com | Category: openxml
Rating: |  Discuss |   Briefcase | 38,265 reads

Reducing Round Trips Part 4

The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!   Read more...
By Andy Warren 2004/04/23 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,947 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,204 reads

Querying XML files using SQL 2000

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!   Read more...
By David Poole 2002/10/11 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 11,868 reads

SQLXML 2.0 (XML for SQL Server 2000)

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.   Read more...
By Additional Articles 2001/10/29 | Source: Microsoft MSDN | Category: news
Rating:  Rate this |   Briefcase | 5,889 reads

Putting 'FOR XML' to Use

Want to take advantage of some of the benefits of using XML for data exchange, take a look at 'FOR XML' in SQL 2000.   Read more...
By Jon Winer 2001/05/10 | Source: SQLServerCentral.com | Category: openxml
Rating: |  Discuss |   Briefcase | 6,033 reads
   Items 1 to 13 of 13   
 
Tags
xml (12)    
t-sql (4)    
basics (3)    
miscellaneous (3)    
performance tuning (2)    
sql server 2005 (2)    
sql server 7 (2)    
updategrams (2)    
xsl (2)    
administration (1)    
advanced querying (1)    
backup / restore (1)    
bulk insert (1)    
configuring (1)    
distributed queries (1)    
dts (1)    
english query (1)    
for xml auto (1)    
indexing (1)    
installation (1)    
monitoring (1)    
news (1)    
openrowset bulk (1)    
replication (1)    
schemas/dtds (1)    
security (1)    
stored procedures (1)    
triggers (1)    
user defined function (udf) (1)    
xquery (1)