Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag XML Rss

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

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,061 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,261 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,122 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,064 reads

Using XQuery to remove duplicate values or duplicate nodes from an xml instance

Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...  Read more...
By Arthur Olcot 2012/12/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 7,840 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 | 1,996 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,737 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,620 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,435 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,486 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,039 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,952 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,310 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,011 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,064 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,102 reads

XML index

By Ravi Kumar SV 2012/07/17 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,080 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 | 4,179 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 | 674 reads
<< Newer    Items 41 to 60 of 287    Older >>
 
Tags
t-sql (40)    
miscellaneous (32)    
basics (28)    
sql server 2005 (21)    
integration services (ssis) (15)    
openxml (13)    
xquery (12)    
stairway series (11)    
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 and 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)    
deadlocks (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)    
pivot (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 (1)    
sql schema (1)    
sql server (1)    
sql spackle (1)    
sql xml (1)    
sqlclr (1)    
sqlxml (1)    
stuff (1)    
system development life cycle (1)    
table (1)    
try_convert() (1)    
tvp (1)    
typed xml (1)    
unique (1)    
unpivot (1)    
untyped xml (1)    
user defined function (udf) (1)    
user-defined data types (1)    
vbscript (1)    
xhtml (1)    
xmla (1)    
xpath (1)    
xportxml (1)