Solved

OPENXML Case Sensitive in SQL 2000

Posted on 2009-03-29
1
456 Views
Last Modified: 2012-05-06
I found that OpenXML seems to be case sensitive,
it means that it cannot find match columnname if case is different.

Case-Sensitive is not good for me,  I hope to set it up to case insensitive,
is it possible? I can do it through my programming language. But want to know is it possible in SQL 2000 itself.
0
Comment
Question by:renjitkumar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 31

Accepted Solution

by:
James Murrell earned 250 total points
ID: 24016459
found this
XML is case sensitive ....

you may require to include some case insensitive SGML parser in your stored
procedures.

also this may help http://www.eggheadcafe.com/conversation.aspx?messageid=29554717&threadid=29554683
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question