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

Content with tag XML Rss

<< Newer    Items 41 to 60 of 279    Older >>
 

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,294 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,200 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 | 7,557 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 | 16,011 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 | 11,552 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 | 14,239 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 | 31,035 reads

Stairway to XML

Although XML is conceptually simple, its use as an equal partner datatype within a relational database, with full searching, validation and manipulation of data, is not intuitive. Now that the industry is more conscious of the use of semi-structured data and data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to become conversant with the technology and appreciative of the cases where XML technologies enhance applications and their development. Robert Sheldon flexes his talent to make the complicated seem simple.  Read more...

SQL Server 2008 and XML

By Sreepathi 2012/08/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,067 reads

XML index

By Ravi Kumar SV 2012/07/17 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,057 reads

Shredding a simple xml structure to a single row flat table

I was helping out a user on the forums the other day where they were asking questions about shredding an...  Read more...
By 2012/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,716 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 | 659 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,281 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,752 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,016 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,485 reads

Basics of XML and SQL Server, Part 1: Streaming XML

This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.  Read more...
By Stan Kulp 2012/03/07 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 6,884 reads

Converting String Data to XML and XML to String Data

In general XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, such as ' entitization'. What do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid.   Read more...
By Additional Articles 2012/02/07 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,677 reads

Introduction to XML DML (Part 3) - Using the modify() method: delete

This is the last part of a 3 part blog which will attempt to show some different ways of how...  Read more...
By 2012/02/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,062 reads

XML to Relational

By Stewart Campbell 2012/01/27 | Category: xquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,174 reads
<< Newer    Items 41 to 60 of 279    Older >>
 
Tags
t-sql (33)    
miscellaneous (32)    
basics (28)    
sql server 2005 (21)    
integration services (ssis) (15)    
openxml (13)    
stairway series (11)    
xquery (10)    
stored procedures (9)    
programming (8)    
sql server 7 (8)    
xsl (8)    
blogs (7)    
indexing (7)    
performance tuning (6)    
string manipulation (5)    
xsd (5)    
c# (4)    
openrowset (4)    
schemas/dtds (4)    
updategrams (4)    
visual basic 6 (4)    
ado (3)    
bulk insert (3)    
computed columns (3)    
database design (3)    
etl (3)    
news (3)    
sql server 2008 (3)    
vb.net (3)    
web service (3)    
xslt (3)    
administration (2)    
asp (2)    
auditing (2)    
bcp (2)    
bulk import (2)    
comma seperated (2)    
delimited strings (2)    
for xml (2)    
for xml path (2)    
monitoring (2)    
namespaces (2)    
parsing delimited string (2)    
reporting services (ssrs) (2)    
security (2)    
strategies (2)    
triggers (2)    
ado.net (1)    
advanced querying (1)    
amo (1)    
atom (1)    
backup / restore (1)    
bi (1)    
bulk load (1)    
bulkimport (1)    
check constraints (1)    
configuring (1)    
create (1)    
cross apply (1)    
cube (1)    
data dictionary (1)    
database objects (1)    
datatypes (1)    
deadlock (1)    
deterministic (1)    
development (1)    
distributed queries (1)    
documenting code (1)    
dts (1)    
dynamic sql (1)    
editorial (1)    
email (1)    
english query (1)    
execute (1)    
export (1)    
export data (1)    
extended properties (1)    
for xml auto (1)    
foreign keys (fk) (1)    
ftp (1)    
functions (1)    
hierarchies (1)    
import (1)    
installation (1)    
integers (1)    
kml (1)    
linq (1)    
list (1)    
mds (1)    
nodes (1)    
nodes() (1)    
null (1)    
object dependencies (1)    
openrowset bulk (1)    
parameters (1)    
parse (1)    
parsing (1)    
persisted (1)    
primary key (pk) (1)    
replication (1)    
row_number() (1)    
scalability (1)    
schema validation (1)    
sebastian (1)    
showplan (1)    
shred (1)    
smtp (1)    
soa (1)    
sparse columns (1)    
split (1)    
split string (1)    
sql schema (1)    
sql server (1)    
sql spackle (1)    
sql xml (1)    
sqlclr (1)    
sqlxml (1)    
system development life cycle (1)    
table (1)    
tvp (1)    
typed xml (1)    
unique (1)    
untyped xml (1)    
user defined function (udf) (1)    
user-defined data types (1)    
vbscript (1)    
xhtml (1)    
xmla (1)    
xportxml (1)