Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Static Typing   (RSS)

Silent XQuery failures

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></test></root>'

Download SP1 today!

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

DML operations on multiple nodes

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 mySchemas
Posted by denisruc | 2 Comments
Filed under: ,

Document and content

Document and content are two options you can use in SQL Server 2005 when typing an XML column or variable with an XML schema collection. To put it simply document means only XML documents should be accepted (exactly one top level element) while content

Static typing and substitution groups

Since I’ve recently talked about both static typing and substitution groups maybe it’s time to see what happens when they meet. If you’ve already read my posts about the effects of the type substitution mechanism on static typing ( part I and part II
Posted by denisruc | 0 Comments
Filed under:

New blog by a SQL Server 2005 tester.

My fellow SDET Galex has started his own blog . If you're interested in the new XML functionality provided in SQL Server 2005 this is another great place to get some valuable information. Galex is our a resident expert on simple types (a feature which
Posted by denisruc | 0 Comments
Filed under: ,

Effects of the type substitution mechanism on static typing (part I)

The XML schema specs define a mechanism that allows for the use of derived types in instance documents. In short, if a schema contains an element ‘E’ of type ‘T’, and if there is a type ‘T1’ derived from ‘T’ then we can set the type of any instance of
Posted by denisruc | 3 Comments
Filed under: ,

For more info on XQuery singleton issues

My fellow SDET John Gallardo has written this follow up to the post I wrote yesterday about singleton errors. John digs a bit deeper, and addresses performance issues. He also goes over the use of the DOCUMENT property and its effects on static typing.
Posted by denisruc | 0 Comments
Filed under:

Single node required

This is one of the most common static typing errors you’re likely to encounter. Somewhere in your XQuery a single node is expected but the static type of the expression you wrote indicates that it can possibly return multiple nodes. For example, let’s
Posted by denisruc | 3 Comments
Filed under:

An introduction to static typing.

XQuery in SQL Server 2005 is a statically typed language. This means type errors may be raised during query compilation when an expression returns a value that has a type or cardinality that is not accepted by a particular function or operator. In short,
Posted by denisruc | 6 Comments
Filed under:

Welcome

Welcome to my newly created blog. My name is Denis Ruckebusch. I've been part of the test organization at Microsoft for the past 6 years. I spent the last 4 working on the new XML datatype feature in SQL Server 2005. My main area of focus is typed XML.
 
Page view tracker