SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag XML Rss

   Items 1 to 20 of 294    Older >>
 

Using T-SQL to Fix Bad Data in XML Documents Using FLWOR

Learn how to use T-SQL to fix contents of an XML document using FLWOR  Read more...
By Additional Articles 2019/01/17 | Source: MSSQLTips.com | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,504 reads

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.  Read more...
By Diogo Castro 2018/08/07 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,142 reads

Examples of using XQuery to update XML Data in SQL Server

What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three operational keyword sets: insert, replace value of, and delete. Seth Delconte takes a closer look.  Read more...
By Additional Articles 2018/07/11 | Source: MSSQLTips.com | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,683 reads

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.  Read more...
By Additional Articles 2017/09/28 | Source: SimpleTalk | Category: json
Rating:  Rate this |   Briefcase | 6,065 reads

XML import from a Cross-tab Report

Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.  Read more...
By Wayne Findley 2017/06/08 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 346 reads

Free ebook: Stairway to SQL Server XML

Free download to all Simple Talk users. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML.  Read more...
By Additional Articles 2017/06/02 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 6,132 reads

Yet another SSIS XML Destination

See a simple script to generate an XML file in SSIS.  Read more...
Rating: |  Discuss |   Briefcase | 931 reads

Finding the name

By Steve Jones 2017/01/20 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 991 reads

A Possible Alternative to SQL UNPIVOT

Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.  Read more...
By Paul Milligan 2017/01/16 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 2,076 reads

The Attribute

By Steve Jones 2016/10/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,227 reads

min Function (XQuery)

By Mikael Eriksson 2016/08/25 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,120 reads

Querying XML

By Steve Jones 2016/06/22 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,196 reads

Inserting XML

By Steve Jones 2016/06/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,442 reads

Why STUFF

By Steve Jones 2016/05/04 | Category: stuff
Rating: (not yet rated) |  Discuss |   Briefcase | 1,743 reads

Converting to XML

By Steve Jones 2016/03/30 | Category: try_convert()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,255 reads

Extract the titles from XML

By Steve Jones 2015/07/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,532 reads

SQLXML Bulk Loader Basics

SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way of heaving large quantities of data into SQL Server databases. SQLXML is very versatile, and once set up is wonderfully reliable ETL system, but isn't trivial to learn. Adam Aspin comes to the rescue with a simple guide.  Read more...
By Additional Articles 2015/06/23 | Source: SimpleTalk | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 4,916 reads

Deterministic

By Stewart Campbell 2015/04/16 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 1,642 reads

Computed Column

By Stewart Campbell 2015/04/14 | Category: computed columns
Rating: (not yet rated) |  Discuss |   Briefcase | 1,740 reads

Parse XML to table

A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.  Read more...
By Steven Willis 2015/04/08 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 4,329 reads
   Items 1 to 20 of 294    Older >>
 
Tags
t-sql (41)    
miscellaneous (32)    
basics (28)    
sql server 2005 (21)    
integration services (ssis) (17)    
openxml (13)    
xquery (13)    
stairway series (11)    
stored procedures (9)    
programming (8)    
sql server 7 (8)    
xsl (8)    
blogs (7)    
indexing (7)    
performance tuning (6)    
openrowset (5)    
string manipulation (5)    
xsd (5)    
c# (4)    
schemas+dtds (4)    
sql server (4)    
updategrams (4)    
visual basic 6 (4)    
ado (3)    
bulk insert (3)    
computed columns (3)    
database design (3)    
etl (extract, transform, and load) (3)    
for xml (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 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)    
ebook (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)    
html (1)    
import (1)    
installation (1)    
integers (1)    
json (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)    
spackle (1)    
sparse columns (1)    
split (1)    
split string (1)    
sql (1)    
sql schema (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)    
yaml (1)