var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: upper/low case in table name
i've been seaching if the question has already been asked on the forum but found no answer.
is it possible with SQL Server 2000 to query table without wondering if its name is upper or lower case ?
For example :
TABLENAME = TBTEST
if i use a select from tbtest, i will get an error message. Is there a way to make it work ?
Does it depend on the collaction sequence (although i'm not talking about the data stored in the table but the name of the table itself) ?
It seems this behaviour was not present with SQL Server 7.
Any ideas dudes ?
Depends how the database or server was created.
It can be case sensitive or insensitive.
I thought the initial database/servers parameters was only concerning data, not the table names themselves.
When the server was created i setup the server with the following parameters :
So you say there is no issue to this problem although i re-create the database with correct parameters ?
create database dddd collate Latin1_General_CI_AI
will give you a case insensitive database so you can access tables irrespective of case in the identifier.
Beware though as you will now have a database with a different collation to master and tempdb.
Any temp tables will still be case sensitive.