posted on Saturday, March 03, 2007 3:56 PM
Roanoke Code Camp - Rob Ericsson - SQL Server 2005 XML Datatype
Rob Ericsson is presenting on the xml Data Type in SQL Server 2005.
As I arrive, Rob is explaining xml data type conversions: you can convert from text to xml, but it's very difficult to convert back.
Rob dives into a comparison between SQL Server 2000 and SQL Server 2005 xml functionality. It's nice that SQL Server 2005 gives us the option of formatting the XML into elements - where we were limited in SQL Server 2000 to an attribute-based format. By adding ",xmlschema" to the query, we can generate a schema along with the data - how cool!
Rob is a great speaker!
Technorati Tags: Roanoke Code Camp Rob Ericsson XML data type SQL Server