SQLServerCentral.com Scripts tagged XML

Convert XML to String with formatting

Fri, 15 Mar 2013 06:00:00 UT

Converts xml value into multi line string with indents

OPEN XML Join

Fri, 04 Feb 2011 07:00:00 UT

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

Stored procedure to script tables, has many options

Tue, 01 Feb 2011 07:00:00 UT

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.

Another way to get a table list from a string

Tue, 15 Jun 2010 06:00:00 UT

I prepared this version (my original did not used XML) By being helped by forums feedback from SQL central Forward it to yours peers.

SQL Server 2005 - Work with Flat Files

Tue, 03 Nov 2009 07:00:00 UT

It's a scripts about working with Flat Files

Script SQL Table Schema as XML-XSD

Wed, 28 Oct 2009 06:00:00 UT

When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.

Table-Valued Function to Split Strings with Xml

Wed, 08 Jul 2009 06:00:00 UT

Splits a string using the xml parser.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Export/import relational data across SQL Servers

Fri, 03 Jul 2009 06:00:00 UT

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.

XML Bulk Dynamic Inserting Records

Sat, 22 Nov 2008 07:47:24 UT

Inserting XML bulk Records into Corresponding tables.

Create a single string from an entire table

Mon, 15 Sep 2008 11:16:41 UT

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.

XML Parsing

Thu, 07 Aug 2008 12:01:16 UT

Scripts parses a XML string to get its values

XML Index

Fri, 19 Sep 2008 06:00:00 UT

Checking XML indexs with a sample.