General information
Forum:
Microsoft SQL Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only