Using OPENXML in SQL Server

This video shows you how to use OPENXML in SQL Server.

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.

Bob McLeod on 11/26/2008

Very good introduction.

Sue Amin on 11/26/2008

CAN I GET A PRINT OUT OF THIS VIDEO FOR A FUTURE REFERENCE? OR COULD I SAVE THIS VIDEO CLIP?

Steve Harris on 11/26/2008

concise and informative

Elena Feier on 11/26/2008

All I get is Stream not found? I have tried a few videos. Am I missing something? There is something i should install?

Julie on 11/26/2008

quick but still very helpful

luther smith on 11/26/2008

Spoken rather quickly.

Dave on 11/27/2008

I'm glad to see some information to demonstrate xml shredding. When I figured out how to do this, examples and information were pretty scant. Videos such as this will open a lot of eyes and be very helpful to others who are unaware of this functionality in SQL Server. Keep up the good work

RavikumarChendra on 11/28/2008

nice

Richard Ray on 9/24/2010

An example with multiple rows would have been helpful.

Mai Grapes on 3/15/2011

wouldn't load

Alfred on 3/16/2011

I cant see it either

Robert on 3/16/2011

Wouldn't load for me either! :(

WChaster on 3/31/2011

zoom and we're done.

Charlie Bruno on 5/12/2011

Just a note, the last video on maintaining full text indexes did not load and run.

Dave on 5/12/2011

This is very useful information. I have just started working with xml files.

Mark Horninger on 5/12/2011

Good info!

Carlos B. Vasquez on 5/12/2011

Useful hint!!!

robin.tanner on 5/12/2011

Would have been nice to see what you need to do for the where clause!

Dan Taylor on 5/12/2011

excellent

Hetal on 5/12/2011

This video okay

Cornelius Hendricks on 5/12/2011

This is just what I needed ~ Thanks

Paul E Richmond on 5/12/2011

Concise and clear..... Wish it covered more but I guess that's the point of these.

Steve Duck on 5/12/2011

succinct

Michael Neymit on 5/12/2011

short and sweet. Need a way to save these videos in some sort of "Briefcase"!

Rebecca Scott on 5/13/2011

great!

Steve Harris on 5/13/2011

maybe go back and show the root in the xml document so that everybody could see the structure

Russell Todd on 5/15/2011

example a little weak - xml has only one contact - what about several contacts with a where clause retrieve?

Peter Voutov on 5/16/2011

I suppose this depends on what version of SQL Server you have, but it's a lot less code to simply use the new XML data type. Suppose your document was in a variable called @Doc, then your example would be something along the lines of: (This is not tested code, but should be close enough) select Contact.value('firstname[1]', nvarchar(50)) from @Doc.nodes('root/Person/contact') as Contacts([Contact])

Daniel Luxembourger on 6/3/2011

simple and clear! Very good!

sushmita on 6/17/2011

thanx was useful the data migration will be easier..

Maurice Ivory on 8/5/2011

Good stuff!!!

Maurice Ivory on 10/24/2011

This was interesting to me.