SQL: OPENXML and case sensitivity

Posts: 120
Comments: 117
Trackbacks: 22

<< SQL Profiler bug | Home | last modified date for stored procedure >>

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.; posted on Thursday, June 07, 2007 8:43 AM Print

Comments

# re: SQL: OPENXML and all null results: Hila; 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)

# re: SQL: OPENXML and case sensitivity: Vipsis; 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 Comment

Title *
Name *
Email
Url
Comment *: Remember Me?

Enter the code shown above

Archives

Post Categories

News