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

Content with tag XML Rss

   Items 1 to 20 of 265    Older >>
 

Object dependencies in xml format

Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio. It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.  Read more...
By Peter Sloboda 2014/07/21 | Source: SQLServerCentral.com | Category: object dependencies
Rating: (not yet rated) |  Discuss |   Briefcase | 594 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 | 12,465 reads

12 SQL Server XML Questions You Were Too Shy To Ask

Robert Sheldon answers 12 questions about XML, including situations you would want to use XML, and how to do basic tasks.  Read more...
By Additional Articles 2014/05/07 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 6,504 reads

XML Workshop : Utilizing Relational Data In XML Files

Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.  Read more...
By Matthew Pettit 2014/04/24 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 3,977 reads

XML Schema validation in SQL Server

An introduction to the XML Schema Collection and XML validation.  Read more...
By Eirikur Eiriksson 2014/04/17 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 4,165 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 | 28,558 reads

Sending a Variable Number of Elements in a Parameter

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.  Read more...
By Alex Grinberg 2014/02/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,422 reads

value() Method (xml Data Type)

By Mikael Eriksson 2014/01/28 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 1,658 reads

SQL Server Deadlocks by Example

In this article, Gail Shaw looks at how you can identify common types of deadlock, the difference between a deadlock and severe blocking, and how to avoid and fix the most common deadlock types.  Read more...
By Additional Articles 2014/01/28 | Source: SimpleTalk | Category: deadlock
Rating:  Rate this |   Briefcase | 3,664 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,123 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,123 reads

Removing HTML formatting tag - BR - from XML using XQuery

This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...  Read more...
By ArthurOlcot 2013/11/07 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,514 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 2013/08/05 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,493 reads

Export to XML Using SSIS

Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.  Read more...
By Additional Articles 2013/06/27 | Source: SQL Server Performance | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,960 reads

Loading XML Data into SQL Server (SQL Spackle)

Learn how to load data in an XML file into a table in SQL Server.  Read more...
By Wayne Sheffield 2013/05/31 (first published: 2011/01/03) | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 19,593 reads

Using XML from data variable option in SSIS

Learn how you can manipulat XML documents solely in memory. No file required.   Read more...
By Cindy Conway 2013/05/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,250 reads

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 | 2,700 reads

Convert XML to String with formatting

Converts xml value into multi line string with indents  Read more...
By Andrei Solntsev 2013/03/15 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,408 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...
Rating: |  Discuss |   Briefcase | 4,203 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 | 4,740 reads
   Items 1 to 20 of 265    Older >>
 
Tags
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)    
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 / 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)