Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time.
If you don't want to waste a lot of time figuring out why the results of your OPENXML query are all NULL, never forget that it's case sensitive.  I'm sure it's already obvious to those who use XML often and are acutely aware that it's case sensitive, but if you spend most of your time doing SQL you tend to forget about case sensitivity. Posted on Thursday, June 7, 2007 8:43 AM all tech stuff , SQL Server | Back to top

Comments on this post: SQL: OPENXML and case sensitivity

# re: SQL: OPENXML and all null results
Requesting Gravatar...
Or it could be that you're referring to attributes instead of elements and vice-versa (check the 3rd parameter of OPENXML)
Left by Hila on May 15, 2008 4:20 PM

# re: SQL: OPENXML and case sensitivity
Requesting Gravatar...
I wasted half of the day to find a problem.
I`m using 2005 and 2008 SQL servers and I was wondering - on 2005 my procedure works, but in 2008 not.
Great Job!
Left by Vipsis on Dec 17, 2008 12:45 AM

Your comment:
 (will show your gravatar)

Copyright © Alex Bransky | Powered by: