Quickly Creating XML Schemas in SQL Server 2005 / 2008

Creating XML schemas in SQl Server 2005 / 2008 can be a tedious process. This video shows you how to quickly create an XML schema in SQL Server 2005 / 2008

Kendal Van Dyke is a Senior DBA with Channel Intelligence in Celebration, Florida. He uses XML extensively in the database at work and believes that the improvements to XML handling in SQL 2005 substantially change how and why we handle XML.

chapas on 11/18/2008

Short and simple

thomas taylor on 11/18/2008

Great quick and to the point

Julie on 11/18/2008

very good!

Matt Dobson on 11/18/2008

Informative. Straight-forward & on-topic. Thanks!

benik9 on 11/18/2008

Very good. The code worked as shown on SSMS. I ran the same code on Toad for Sql server, but it gave me two lines. Didn't look at it in detail, but I thought it was strange.

Dave on 11/27/2008

Sweet!

John O'Sullivan on 12/3/2008

good video

Moe on 2/20/2010

Awesome. Very handy tip.

Stephen on 6/14/2010

Nice introduction and start for ideas

Dean Gross on 12/15/2010

excellent tip, some advice about "true" schema tools would be helpful.

John H Davis on 4/20/2011

Excellent info. Just what I was looking for.

rajesh on 5/9/2011

excellent

Jonathan on 5/9/2011

Thanks Kendal, nice tip.

josh on 5/9/2011

cool!

erick on 5/9/2011

Nice!

Andy Obregon on 5/9/2011

Nice and simple, look forward to more.

David Burnett on 5/9/2011

focused content, excellent tone and pace. I learned something.

Keith Cooper on 5/9/2011

could have shared a little more information about the XMLSCHEMA('xxxxxxxxxxxxxxxxxxxxxxx') option. Other than that the information is good.

Douglas Duncan on 5/9/2011

seems like the video was cut short

Michael Neymit on 5/10/2011

Nice short-cut!

Bridget on 5/11/2011

very informative, short and to the point

ravi on 5/11/2011

good one

Steve Harris on 5/16/2011

When would this be needed? What are some of the other options and when would you use those?

95E58BF5D5 on 9/7/2011

I want to generate multiple different tables schema with records in single output xml. How to do it?

Maurice Ivory on 10/21/2011

I should be able to use this information.

T. Carnahan on 1/16/2012

Great shortcut!