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
Keep up to date - daily newsletter:
Sign up
Articles with tag
XML
Search for
any
content tagged
xml
<< Newer
Items 21 to 40 of 211
Older >>
Ad-Hoc XML File Querying
When you need to shred just part of the data within a large XML file into a SQL Server table, the most efficient way is to just select what you need via XQuery or by using XPath, before shredding it into a table. But precisely how would you do that?
Read more...
By
Additional Articles
2013/03/28
|
Category:
xml
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,125 reads
Shred XML column using SSIS
This article describes a way using SSIS to shred a XML column from a source table into its respective columns in the destination table.
Read more...
By
Arun Mishra
2013/02/27
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
5,056 reads
Stairway to XML: Level 10 - Converting XML Data
In this Level, we look at how to convert string values to XML and how to convert XML to character types.
Read more...
By
2013/02/13
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
6,164 reads
Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012
Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference.
Read more...
By
Additional Articles
2013/02/06
|
Source:
SimpleTalk
|
Category:
indexing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,427 reads
Stairway to XML: Level 9 - Creating XML-Based Functions
In this Level, we’ll look at how to use XML methods within user-defined functions to return XML fragments and values from your target XML instance.
Read more...
By
Rob Sheldon
2013/01/30
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
6,187 reads
Stairway to XML: Level 1 - Introduction to XML
In this level, Rob Sheldon explains what XML is, and describes the components of an XML document, Elements and Attributes. He explains the basics of tags, entity references, enclosed text, comments and declarations
Read more...
By
Rob Sheldon
2014/03/26 (first published: 2012/09/20)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
32,349 reads
Stairway to XML: Level 8 - Deleting Data from an XML Instance
in order to use the modify() method to delete data from typed and untyped XML instances, you must pass an XML DML expression as an argument to the method. That expression must include the delete keyword, along with an XQuery expression that defines the XML component to be deleted. Robert makes it seem simple, as usual.
Read more...
By
Rob Sheldon
2012/11/05
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
2,039 reads
Manipulating XML Data in SQL Server
When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from SQL, it is often done 'at arms length'. A shame, since effective use of techniques that go beyond the basics can save much code,
Read more...
By
Additional Articles
2012/11/01
|
Source:
SimpleTalk
|
Category:
xml
Rating:
Rate this
|
Briefcase
|
3,844 reads
Stairway to XML: Level 7 - Updating Data in an XML Instance
You need to provide the necessary keywords and define the XQuery and value expressions in your XML DML expression in order to use the modify() method to update element and attribute values in either typed or untyped XML instances in an XML column. Robert Sheldon explains how.
Read more...
By
Rob Sheldon
2012/10/29
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
4,677 reads
Getting Started With XML Indexes
XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running queries against half a million XML employee records. The execution time of a query is reduced from two seconds to being too quick to measure, purely by creating the right type of secondary index for the query.
Read more...
By
Additional Articles
2012/10/25
|
Source:
SimpleTalk
|
Category:
xml
Rating:
Rate this
|
Briefcase
|
2,521 reads
Stairway to XML: Level 6 - Inserting Data into an XML Instance
The modify method lets you manipulate XML data using XML DML. It can insert, alter or delete data. In this level, Robert shows how to use the method to insert a node into an XML instance.
Read more...
By
Rob Sheldon
2012/10/17
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
6,569 reads
Stairway to XML: Level 5 - The XML exist() and nodes() Methods
The XML exist() method is used, often in a WHERE clause, to check the existence of an element within an XML document or fragment. The nodes() method lets you shred an XML instance and return the information as relational data.
Read more...
By
Rob Sheldon
2012/10/15
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
8,239 reads
Stairway to XML: Level 4 - Querying XML Data
You can extract a subset of data from an XML instance by using the query() method, and you can use the value() method to retrieve individual element and attribute values from an XML instance.
Read more...
By
Rob Sheldon
2014/09/03 (first published: 2012/10/08)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
17,194 reads
Stairway to XML: Level 3 - Working with Typed XML
You can enforce the validation of an XML data type, variable or column by associating it with an XML Schema Collection. SQL Server validates a typed XML value against the rules defined in the schema collection so that INSERT or UPDATE operations will succeed only if the value being inserted or updated is valid as per the rules defined in the Schema Collection.
Read more...
By
Rob Sheldon
2012/10/01
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
12,491 reads
Stairway to XML: Level 2 - The XML Data Type
Robert Sheldon describes SQL Server's XML Data Type, and shows that it is as easy to configure a variable, column, or parameter with the XML data type as configuring one of these objects with any other datatype
Read more...
By
Rob Sheldon
2014/07/18 (first published: 2012/09/26)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
15,231 reads
Stairway to XML: Level 1 - Introduction to XML
In this level, Rob Sheldon explains what XML is, and describes the components of an XML document, Elements and Attributes. He explains the basics of tags, entity references, enclosed text, comments and declarations
Read more...
By
Rob Sheldon
2014/03/26 (first published: 2012/09/20)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
32,349 reads
Learn XML
Steve Jones talks about XML and how it will be more and more important for DBAs to understand this in the future.
Read more...
By
Steve Jones
2012/05/03
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
676 reads
Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS
This SSIS package generates XML invoice documents from data stored in SQL Server, then FTPs and/or Emails them to clients.
Read more...
By
Stan Kulp
2012/04/04
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
6,327 reads
Basics of XML and SQL Server, Part 4: Create an XML invoice with SSIS
This article demonstrates how to build an SSIS package that generates an XML invoice document from data stored in SQL Server and saves it to an XML file.
Read more...
By
Stan Kulp
2012/03/28
|
Source:
SQLServerCentral.com
|
Category:
xml
Rating:
|
Discuss
|
Briefcase
|
2,802 reads
Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS
This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.
Read more...
By
Stan Kulp
2012/03/21
|
Source:
SQLServerCentral.com
|
Category:
xml
Rating:
|
Discuss
|
Briefcase
|
3,108 reads
<< Newer
Items 21 to 40 of 211
Older >>
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.