07
Apr
10

IF xQuery like ‘What?’

 

Every single release of SQL Server and made the product more robust, and well that is the point of a release. The SQL Server offering is no different, but may expand more than other products that I have seen. 15 years ago the person who developed the stored procedures was often asked to install SQL Server. Installing service packs was considered part of the job just like creating DTS packages. Now that we are on the eve of the 2008 R2 release we are seeing that each of these areas is even growing within them self’s. Some of these features are used a lot, other features I don’t see used as often. It could be that I just have not had that much exposure to them.

xQuery is one of these features to me. I know it is in the product, but there is not a lot more I can tell you about it. That was of course until I came across this week’s chapter where Michael Coles gave a very through overview of how to use xQuery and how to use it. Now if I understand this correctly xQuery is not so much a SQL Server language as it is a syntax for looking at your data in your XML.

The core of the chapter centers around getting information out of the XML elements that may be in your database. Just like any other data that is in your database you have to know the best way to:

  • Find It
  • Update It
  • Insert more of It
  • Remove It

I believe this is the first chapter so far in the book where you can consider a topic to be an introduction. When I refer to an introduction its not because the topic is basic or simple but the core part of the chapter is building a foundation. An example of this is the comparison table that Michael included. Here it explains that eq to xQuery is the same as ‘=” to tSQL. Or ge is >=.

There is a plethora of information here to help you get started with xQuery. Not only will you get a start but you will be well on your way to having a solid understanding of the technology.

Advertisements

0 Responses to “IF xQuery like ‘What?’”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Chapters

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 13 other followers