Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » DML » Schema Collections   (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>'

Mixed content (part 3)

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

Restricting the contents of a typed XML column using triggers

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
Posted by denisruc | 0 Comments
Filed under: ,
 
Page view tracker