The Wrecking Bawl

Destructuring query language, one keyword at a time.


News


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.
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Comments

Gravatar # re: SQL: OPENXML and all null results
Posted by Hila on 5/15/2008 4:20 PM
Or it could be that you're referring to attributes instead of elements and vice-versa (check the 3rd parameter of OPENXML)
Gravatar # re: SQL: OPENXML and case sensitivity
Posted by Vipsis on 12/17/2008 12:45 AM
Thanks!!!!
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!
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: