Shredding XML Attributes with the Xquery Value function

Parsing XML inside SQL Server scripts is becoming more popular. This video shows you how to shred attributed based XML with the value function.

Plamen Ratchev has over two decades experience in the software architecture and development field. He has enjoyed building solutions for UNIX, DOS and Windows platforms, with main focus on SQL Server since version 4.21. Plamen is founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance a...

James Moore on 7/27/2009

Excellent! Just what I needed. Thank you so much for your time in presenting this information.

Amy Darroh on 8/24/2009

Nice! Thanks.

Luis Ramos on 9/17/2009

Pretty neat function. Thanks for sharing!

Diana Dee on 9/17/2009

I'd love to have the script available via a link! Perhaps for ALL videos involving scripts ??

borjonx on 9/17/2009

good speaker - clear and not too fast.

Joshua Clausen on 9/17/2009

solid basic overview

F8DA83F0DD on 9/17/2009

Simple and effective.

Plamen Ratchev on 9/18/2009

Diana, the scripts are available for download in the References section on top of the page.

Leonidas on 9/19/2009

just plain good info

Axel Grude on 9/21/2009

Brilliant, very elegant and simple! Kudos to the explanation, extremely concise.

Ahmad Elayyan on 9/27/2009

V.Good

sunil on 10/14/2009

Pretty Good

Keith Badeau on 5/23/2011

As always, great demo. Thank you.

Tim Curtin on 1/11/2012

would have been nice to see how to filter as in a where clause or in the xpath statement...

Thomas Chai on 1/11/2012

Hi, How can you get attribute from subnodes? Thanks, Tom