I will be speaking at the NY Metro SQL Server Users Group on Thursday at 6pm on XQuery in SQL Server. Hope to see you all there.
Using XQuery to Retrieve and Manipulate XML Data with SQL Server 2005
Stephen Forte, Microsoft Regional Director
6:00 PM on October 26, 2006
Microsoft Office in Manhattan
The Axa Financial Building
1290 6th Avenue, NY, NY
Due to new security guidelines at the building, you will have an easier time getting in if you confirm your attendance via email to firstname.lastname@example.org. Otherwise you'll have to wait till someone comes downstairs to sign you in. Also remember to have a photo id with you.
Blogs, Web Services and general interoperability have proliferated the use of XML in recent years. With all of that XML out there, there needs to be an easy way to incorporate XML data with SQL Server relational data.
This session will look at how to use XQuery to retrieve and manipulate XML data inside the database. We'll start with a look at the new XML datatype in SQL Server 2005, then the ability to validate with XML Schema (XSD) and then creating XML indexes for use with XQuery statements. After a brief look at the W3C XQuery specification we quickly move to SQL Server’s implementation of XQuery 1.0. We'll incorporate XQuery in SELECT and WHERE clauses to retrieve information as well as see how to manipulate XML data with XQuery DML.
Pizza and refreshment will be served at the meeting, and there will be a drawing for several giveaways.
Page rendered at Sunday, September 15, 2019 6:38:48 AM (Eastern Daylight Time, UTC-04:00)
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in anyway.