Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tags
XML
,
OpenXML
Items 1 to 14 of 14
XML Workshop : Utilizing Relational Data In XML Files
Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.
Read more...
By
Matthew Pettit
2014/04/24
|
Source:
SQLServerCentral.com
|
Category:
xml
Rating:
|
Discuss
|
Briefcase
|
4,171 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,946 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
|
997 reads
OPENXML
Read more...
By
VM-723206
2009/06/02
|
Category:
xml
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,869 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,393 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,655 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,695 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,332 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,393 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,954 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,208 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,878 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
|
6,439 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,053 reads
Items 1 to 14 of 14
Tags
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 and restore
(1)
bulk insert
(1)
configuring
(1)
distributed queries
(1)
dts
(1)
english query
(1)
etl
(1)
for xml auto
(1)
indexing
(1)
installation
(1)
monitoring
(1)
news
(1)
openrowset
(1)
openrowset bulk
(1)
replication
(1)
schemas+dtds
(1)
security
(1)
stored procedures
(1)
triggers
(1)
user defined function (udf)
(1)
xquery
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.