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

Scripts with tag XML Rss

Search for any content tagged xml

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 16 of 16   

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 | 338 reads

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 | 864 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,309 reads

SQL Server Dynamic XML Tag

Extract data from XML file from dynamic tag. in this below e.g we can add / remove Escalations tag from xml file. and depends on that result will display.  Read more...
Rating: |  Discuss |   Briefcase | 775 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,553 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: SQLServerCentral.com | Category: openxml
Rating: |  Discuss |   Briefcase | 999 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: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,298 reads

Another way to get a table list from a string

I prepared this version (my original did not used XML) By being helped by forums feedback from SQL central Forward it to yours peers.  Read more...
By Bernabe Diaz 2010/06/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,443 reads

SQL Server 2005 - Work with Flat Files

It's a scripts about working with Flat Files 
Rating: |  Discuss |   Briefcase | 1,921 reads

Script SQL Table Schema as XML-XSD

When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.  Read more...
By Banyardi Schmardi 2009/10/28 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,279 reads

Table-Valued Function to Split Strings with Xml

Splits a string using the xml parser. 
By Oscar D Garcia 2009/07/08 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,129 reads

Export/import relational data across SQL Servers

The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.  Read more...
By Ashish Kumar-1095774 2009/07/03 | Source: SQLServerCentral.com | Category: export
Rating: |  Discuss |   Briefcase | 1,501 reads

XML Bulk Dynamic Inserting Records

Inserting XML bulk Records into Corresponding tables. 
By gandhi.mk 2008/11/22 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,747 reads

Create a single string from an entire table

I have a need to pass an entire table of data as a parameter to a COM+ component. I found that a simple XML call did the job.  Read more...
By Mike Bennett 2008/09/15 | Source: SQLServerCentral.com | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 452 reads

XML Parsing

Scripts parses a XML string to get its values  Read more...
By Amruta Shimpi 2008/08/07 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 2,153 reads

XML Index

Checking XML indexs with a sample. 
By abmore 2008/09/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,446 reads
   Items 1 to 16 of 16