Posted by M A Srinivas on 03/15/07 05:42

On Mar 14, 11:59 pm, sweetpota...@yahoo.com wrote:
> Hi,
>
> I believe my SQL server was configured as Case sensitivity. I have a
> number of stored procedures which were moved from a non-Case
> sensitivity SQL server. Because of the Case sensitivity, I have to do
> a lot of editing in those stored procedures. Is there a quick way to
> avoid the editing?
>
> Something like ignoring the case in one statement?
>
> Thanks in advance, your advice will be greatly appreciated.

I think by changing the collation of your database to case
insenstitvity may help
but this may cause problems when you create #temp tables as tempdb
will have server collation

If your column and table names are in lower case , you can modify the
SP by selecting the SP and changing to lowercase (SHIFT+CTRL+L) . But
if you have string constants which need to be in uppercase , you need
to change it accordingly

M A Srinivas

• Next in forum: Re: SQL Query help
• Prev in forum: Exam:070-229-An Excellent Resource
• Thread view: Re: Case sensitivity in SQL -- ignore

[Reply to this message]