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

Scripts with tag XML Rss

Search for any content tagged xml

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

Add a script

   Items 1 to 13 of 13   

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: | Category: xml
Rating: |  Discuss |   Briefcase | 2,393 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: | Category: xml
Rating: |  Discuss |   Briefcase | 1,384 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 | 925 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,226 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,429 reads

SQL Server 2005 - Work with Flat Files

It's a scripts about working with Flat Files 
By Luan Moreno M. Maciel 2009/11/03 | Source: | Category: etl
Rating: |  Discuss |   Briefcase | 1,884 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: | Category: xml
Rating: |  Discuss |   Briefcase | 1,161 reads

Table-Valued Function to Split Strings with Xml

Splits a string using the xml parser. 
By Oscar D Garcia 2009/07/08 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 1,069 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: | Category: export
Rating: |  Discuss |   Briefcase | 1,423 reads

XML Bulk Dynamic Inserting Records

Inserting XML bulk Records into Corresponding tables. 
By 2008/11/22 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 1,575 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: | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 443 reads

XML Parsing

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

XML Index

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