Stephen Forte at GUVSM

Groupe d'Usagers Visual Studio Montréal (GUVSM)

Groupe d'Usagers Visual Studio Montréal (GUVSM)

Microsoft (Montréal Office)

Suite 450, 2000 Avenue McGill Collège

Montréal, Québec, Canada H3A 3H3

Speaker: Stephen Forte (INETA Speaker, Microsoft Regional Director)

Subject: XML in SQL Server 2005

Date: March 14, 2006 at 6:15 PM EST

Location: Windows Live Local



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

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.

Comments (0)

Skip to main content