SQL Server 2012 MS Case Sentive?

Question

SQL Server 2012 MS Case Sentive?

river1

SSC-Insane

Points: 24309
More actions
April 13, 2015 at 7:40 am

#316631

Hi,
I have a view named SGSCC
If I call it as select * from SGSCC it works fine
If I try to call it as select * from sgcc says that the objects does not exists.
Is SQL Server 2012 MS Case Sensitive?
In SQL Server 2005 this did not happen...

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Y.B. SSChampion Points: 11649 More actions · Answer 1

river1 (4/13/2015)
Hi,
I have a view named SGSCC
If I call it as select * from SGSCC it works fine
If I try to call it as select * from sgcc says that the objects does not exists.
Is SQL Server 2012 MS Case Sensitive?
In SQL Server 2005 this did not happen...

You are missing an 's' in the lower case statement unless that was a typo here. 😀

SELECT quote FROM brain WHERE original = 1
0 rows returned

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 2

river1 (4/13/2015)
Hi,
I have a view named SGSCC
If I call it as select * from SGSCC it works fine
If I try to call it as select * from sgcc says that the objects does not exists.
Is SQL Server 2012 MS Case Sensitive?
In SQL Server 2005 this did not happen...

Try

SELECT *

FROM dbo.sgscc;

😎

There is one "S" missing in the lower case query.

Check the collation for the databases

SELECT

SDB.name

,SDB.collation_name

FROM sys.databases SDB;

Latin1_General_CI_AS <-- Case Insensitive

Latin1_General_CS_AS <-- Case Sensitive