SQL: OPENXML and case sensitivity

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.

Print | posted on Thursday, June 07, 2007 8:43 AM

Comments on this post

# 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

Your comment:

 (will show your gravatar)
 
Please add 1 and 4 and type the answer here: