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 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 15 of 15   
 

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 | 715 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,560 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 | 706 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,421 reads

OPEN XML Join

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 | 945 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,241 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,432 reads

SQL Server 2005 - Work with Flat Files

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

Table-Valued Function to Split Strings with Xml

Splits a string using the xml parser.  Read more...
By Oscar D Garcia 2009/07/08 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,083 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,432 reads

XML Bulk Dynamic Inserting Records

Inserting XML bulk Records into Corresponding tables.  Read more...
By gandhi.mk 2008/11/22 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,615 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 | 446 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,009 reads

XML Index

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