Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Case sensitive Instance
Message
 
To
16/07/2002 12:18:38
General information
Forum:
Microsoft SQL Server
Category:
Installation
Miscellaneous
Thread ID:
00679070
Message ID:
00679230
Views:
19
Ok, Collation can be used at the data level.... fine and actually, this is specific to each installation.

My problem is at TSQL level. It seems that variables used in TSQL code at this location need to match (case wyse) the declaration. Here is my example:

DECLARE @MyVar int

SET @myvar = 0

Will bomb at execution time.

I've not tested this myself, but this was reported to me by an installer at the client site...By changind the case to match the variable declaration, things where back to normal...

I' m surprise of this, I'm coming from Oracle and this was never an issue.

Any clues/orientations/quick fixes for me ?

Thanks.

P.S. I don't know if I've missed a good show here, but this comes as a shock to me...
Previous
Reply
Map
View

Click here to load this message in the networking platform