I'm over 2 months late in writing this post. please forgive me for the delay, especially those of you who were nice enough to leave comments and questions and expected a response. This is my last posting on my "Typed XML" blog. After almost 9 years at...

A newsgroup post I read earlier today reminded me that there are cases where failure to get the expected result when using XQuery can sometimes be difficult to diagnose. Here’s what the poster was doing declare @xml xml set @xml = '<root><test><...

The famous Stardust hotel and casino was torn down today . I was fond of the place since this was the hotel I stayed at when I first visited Vegas in the mid nineties. During our most recent trip to Nevada last summer my wife and I made sure we stopped...

It’s been a few weeks since my last post about mixed content so let’s pick up right where we left off. This time we will look at DML operations on mixed content. We’ll keep using the XML schema as well as the table I created in the first post of this...

One of my colleagues, Brad Richards just started blogging about SQL CLR performance. If you use SQL CLR I strongly suggest that you take a look at this blog . Brad is very knowledgeable about performance and you're likely to learn some very valuable information...

Following last week's introduction to the concept of mixed content, let's look in detail at a validated XML instance with mixed content. Taking a look at the children nodes of the <letter> element Let’s reuse the instance we stored in...

I started working on this two days ago. I quickly realized that when I’m done I’ll most likely have material for multiple posts. My original plan was to finish the article in the next few days, and then publish it as several posts over time. However I...

Last time we looked at what happens to the xsi:nil attributes when replacing the value of a simply typed element. In this post, we’re going to look at complex types. First let’s create a schema collection with complex types and elements. CREATE...

A few months ago I wrote a post about the interesting behavior of the xsi:type attribute . Today we’re going to look at his no so distant relative xsi:nil. But first let’s do a quick recap. Any element can be made nillable by adding the attribute nillable...

In my previous post I mentioned the article I wrote for the September issue of SQL Server Standard Magazine. I heard of one person who was having trouble running the code samples from the article. When I received my copy of the magazine I realized the...

The September issue of SQL Server Standard magazine is devoted to XML. I contributed an article where I look at ways to use XML to solve relational problems. Check it out!

I was recently asked to look at a customer’s question. This person wanted to write a schema that would validate instances like the following one. <TopElement> <a> <element1 att1="data1" att2="data2"/> <an_element att1...

As I said in my previous post, the past few weeks have been demanding and I had little time to spend on blog post. However I recently rediscovered an interesting behavior in typed XML DML and I felt I should make some time for a quick post. Today’s...

If you use XML in SQL Server 2005, and especially if you use it in association with schemas, I suggest you read Brandon's recent blog post about the limitations that were placed on the XML datatype. Brandon is one of our developers and he's got first...

A man named Vincent Ferrari is making headlines today. He called AOL’s costumer service to cancel his account and ran into a less than cooperative representative. The twist is, Vincent was taping the call and posted the recording on his blog . This...

Since we shipped SQL Server 2005 I have seen a few users ask if there was a simple way to insert an XML instance into another one. For simplicity’s sake, in the rest of this post I’m going to assume that all my variables contain valid XML documents (a...

A typed XML column/variable is constrained by a schema collection. That means only instances that can be validated against the schemas in the collection will be accepted. You can tighten the rules a little bit with the use of the DOCUMENT facet, which...

As promised earlier I'm going to give you an example using a real-world schema. I've chosen to work with the Office 2003 schemas but I'm going to limit myself to Word and Excel. First, you need to install the schemas from here . In the T-SQL samples...

Yesterday we released our first Service Pack for SQL Server 2005 . You might remember a while back I had written a small post about being hard at work on SP1. Back then I avoided giving any details for fear of running afoul of corporate policy but since...

In my last post I addressed the issue of non deterministic content models, which can be valid with respect to the W3C’s standards, but which are always rejected by SQL Server 2005. There are a few other XSD features that SQL Server 2005 doesn’t support...

If you’ve been importing XML schemas into SQL Server 2005 you might have encountered this error message XML Validation: XML instances of the content model of type or model group '…' can be validated in multiple ways and are not supported. ...

It's funny how I thought that with SQL Server 2005 out the door I'd have more time to spend on this blog and other long-delayed projects. Boy was I wrong! We kicked the SP1 work in high gear the minute we shipped SQL Server. I probably cannot reveal much...

This blog’s been very quiet this past couple of weeks, and for a very good reason; we were all hard at work putting the finishing touches to SQL Server 2005. We RTM’ed yesterday and if you’re an MSDN subscriber you can already download it (along with...

When I started this blog 3 months ago my sole intent was to share knowledge pertaining to the XML data type in SQL Server 2005. I didn’t think I’d write about anything else. I didn’t even think there was anything else I wanted to write about. Well, it...

If you've been playing with SQL Server 2005's implementation of XQuery for a while you probably know that "delete" is the only operation that allows for multiple target nodes. For example, let's imagine that we have the following table CREATE TABLE...