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 265    Older >>

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: | Category: xml
Rating: |  Discuss |   Briefcase | 2,901 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: | Category: xml
Rating: |  Discuss |   Briefcase | 10,124 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: | Category: xml
Rating: |  Discuss |   Briefcase | 6,704 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,529 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: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,366 reads

XML to Relational

By Stewart Campbell 2012/01/27 | Category: xquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,146 reads

Using XML to pass lists as parameters in SQL Server

Every so often, the question comes up on forums of how to pass a list as a parameter to a SQL procedure or function. Phil Factor provides some examples using XML, and tests them against other popular methods.  Read more...
By Additional Articles 2012/01/26 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,559 reads

Incorporating XML into your Database Objects

XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check constraints, computed columns and defaults. Views and table-valued functions can be used to provide a tabular view of XML data that can be used in SQL Expressions. Robert Sheldon explains how.  Read more...
By Additional Articles 2012/01/20 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 2,224 reads

XML-XSL Transformations in SQL Server

With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.  Read more...
By Cem Güler 2012/01/04 | Source: | Category: mds
Rating: |  Discuss |   Briefcase | 2,898 reads

The XML Methods in SQL Server

The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and attributes within XML have been so foreign to the SQL language as to be somewhat of a barrier to their use. Fortunately, Robert Sheldon has once more managed to make the subject accessible to those of us who just need to get the job done.  Read more...
By Additional Articles 2012/01/03 | Source: SimpleTalk | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 3,395 reads

FOR XML PATH using node tests in column aliases

I've used SQL to generate countless blobs of xml over the years and one feature that I have come to...  Read more...
By 2011/12/20 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,505 reads

Managing Data Dictionaries in DW and DSS Database Applications

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.  Read more...
By Frank A. Banin 2011/12/20 | Source: | Category: bi
Rating: |  Discuss |   Briefcase | 5,317 reads

Working with the XML Data Type in SQL Server

The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful extensions to SQL Server. Robert Sheldon, in the first part of a series, describes how create and index a XML column in a table, and discusses when you should consider using an XML data type.  Read more...
By Additional Articles 2011/12/02 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 2,943 reads


By Ryan Barrett 2011/12/01 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 2,067 reads

XML Configuration files in SQL Server Integration Services

Package configuration files are a great way of providing the values of SSIS package properties so that packages can be used in a far more versatile way. They make the deployment of SSIS packages easier and can provide parameters that are based on the server configuration, or which change for each runtime. They're easy to understand, especially when explained by Rob Sheldon.   Read more...
By Additional Articles 2011/08/25 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 2,337 reads

SQL Peer-to-Peer Dynamic Structured Data Processing Collaboration

Unstructured and XML semi-structured data is now used more than structured data. But fixed structured data still keeps businesses running day in and day out, which requires consistent predictable highly principled processing for correct results. For this reason, it would be very useful to have a general purpose SQL peer-to-peer collaboration capability that can utilize highly principled hierarchical data processing and its flexible and advanced structured processing to support dynamically structured data and its dynamic structured processing. This flexible dynamic structured processing can change the structure of the data as necessary for the required processing while preserving the relational and hierarchical data principles. This processing will perform freely across remote unrelated peer locations anytime and transparently process unpredictable and unknown structured data and data type changes automatically for immediate processing using automatic metadata maintenance.  Read more...
By Additional Articles 2011/06/21 | Source: Other | Category: soa
Rating:  Rate this |   Briefcase | 2,069 reads

SQL Transparent Hierarchical Processing of Relational, XML and IMS Data

The SQL-92 standard introduced the LEFT Outer Join operation which offers a powerful alternative to standard relational processing to perform full hierarchical processing naturally and inherently. This enables SQL to transparently integrate relational data with XML, IMS and other forms of legacy hierarchical data. This can also allow the so far overlooked integration of IMS and legacy data with the Internet and XML, and visa versa.   Read more...
By Additional Articles 2011/04/15 | Source: Other | Category: xml
Rating:  Rate this |   Briefcase | 3,360 reads


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: | Category: openxml
Rating: |  Discuss |   Briefcase | 940 reads

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,237 reads

XQuery for the Non-Expert – @Variable Use

Talk to the Experts In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert...  Read more...
By StrateSQL 2011/01/20 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,137 reads
<< Newer    Items 41 to 60 of 265    Older >>
miscellaneous (32)    
basics (28)    
t-sql (26)    
sql server 2005 (21)    
integration services (ssis) (14)    
openxml (13)    
stairway series (11)    
stored procedures (9)    
xquery (9)    
programming (8)    
sql server 7 (8)    
xsl (8)    
blogs (7)    
performance tuning (6)    
indexing (5)    
string manipulation (5)    
xsd (5)    
c# (4)    
schemas/dtds (4)    
updategrams (4)    
visual basic 6 (4)    
ado (3)    
bulk insert (3)    
database design (3)    
etl (3)    
news (3)    
openrowset (3)    
sql server 2008 (3) (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) (1)    
advanced querying (1)    
amo (1)    
atom (1)    
backup / restore (1)    
bi (1)    
bulkimport (1)    
check constraint (1)    
computed columns (1)    
configuring (1)    
create (1)    
cross apply (1)    
cube (1)    
data dictionary (1)    
data types (1)    
database objects (1)    
deadlock (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 (1)    
for xml auto (1)    
foreign keys (fk) (1)    
ftp (1)    
functions (1)    
hierarchies (1)    
import (1)    
installation (1)    
kml (1)    
linq (1)    
list (1)    
mds (1)    
nodes (1)    
null (1)    
object dependencies (1)    
openrowset bulk (1)    
parameters (1)    
parse (1)    
parsing (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)    
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)