Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Static Typing » DML   (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>'

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: ,
 
Page view tracker