Sign Up! | Tags | Domains | Statistics | Options | Advanced Search
|
Sign Up! | Tags | Domains | Statistics | Options | Advanced Search |
msdn.com » Typed XML in SQL Server 2005 - Apr 20, 2007
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 …
Also tagged: xsd, dml, static typing
msdn.com » Typed XML in SQL Server 2005 - Mar 14, 2007
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 …
msdn.com » Typed XML in SQL Server 2005 - Jan 24, 2007
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 …
Also tagged: xsd
msdn.com » Typed XML in SQL Server 2005 - Jan 3, 2007
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. The customer had two requirements for the children of element ‘a’. 1 …
Also tagged: xsd
msdn.com » Typed XML in SQL Server 2005 - Jan 3, 2007
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 …
Also tagged: xsd, thoughts and digressions
msdn.com » Typed XML in SQL Server 2005 - Jan 3, 2007
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 …
Also tagged: dml
msdn.com » Typed XML in SQL Server 2005 - Jan 3, 2007
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 …
Also tagged: xsd
msdn.com » Typed XML in SQL Server 2005 - Jan 3, 2007
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 …
Also tagged: xsd, thoughts and digressions, static typing
msdn.com » Typed XML in SQL Server 2005 - Jan 3, 2007
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 …
Also tagged: xsd
msdn.com » Typed XML in SQL Server 2005 - Jan 3, 2007
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 …
Also tagged: xsd