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

Add a script

   Items 1 to 12 of 12   
 

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,186 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 | 899 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,169 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,414 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,849 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,113 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,043 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,380 reads

XML Bulk Dynamic Inserting Records

Inserting XML bulk Records into Corresponding tables.  Read more...
By gandhi.mk 2013/06/19 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,377 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 2013/06/19 | Source: SQLServerCentral.com | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 430 reads

XML Parsing

Scripts parses a XML string to get its values  Read more...
By Amruta Shimpi 2013/06/19 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,875 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,286 reads
   Items 1 to 12 of 12