With all of that XML out there, there needs to be an easy way to incorporate XML data with SQL Server relational data. SQL Server 2000 introduced the FOR XML clause that produces XML from relational output and SQL Server 2005 greatly enhances that. What SQL Server 2000 lacked was a native way to store and work with XML, you were reduced to storing XML in a TEXT field. SQL Server 2005 has a new intrinsic XML data type that can be used in tables, variables, stored procedures, etc. The advantage is that you can use a whole range of XML Technologies inside of SQL Server that you could not use before including the ability to validate with XML Schema (XSD) and create an XML index for use with XPath and XQuery statements. XQuery makes it very easy to retrieve and manipulate XML in and outside the database. This session will look at how to use this new data type and XQuery in your SQL Server 2005 applications.
Stephen Forte is the Chief Technology Officer and co-founder of Corzen, Inc, a Manhattan (USA) based provider of online market research data for Wall Street Firms. Stephen is also the Microsoft Regional Director for the NY Metro region as well as an MVP and INETA speaker. He speaks regularly at industry conferences like Tech*Ed, North Africa Developers Conference and other conferences around the world. He is an author of Programming SQL Server 2005 (MSPress) as well as other books on application and database development. He currently is the co-moderator and founder of the NYC .NET Developer User Group.