12 SQL Server XML Questions You Were Too Shy To Ask

Robert Sheldon answers 12 questions about XML, including situations you would want to use XML, and how to do basic tasks.

XML Workshop : Utilizing Relational Data In XML Files

Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.

XML Schema validation in SQL Server

An introduction to the XML Schema Collection and XML validation.

Sending a Variable Number of Elements in a Parameter

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.

value() Method (xml Data Type)

SQL Server Deadlocks by Example

In this article, Gail Shaw looks at how you can identify common types of deadlock, the difference between a deadlock and severe blocking, and how to avoid and fix the most common deadlock types.

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)

Removing HTML formatting tag - BR - from XML using XQuery

This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...

Parse XML to table

A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.

Export to XML Using SSIS

Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.