Feature Request...variable casing consistency...
swjohnson
Posts: 30
This is from my programming background and variable consistency.
I see alot of my VB programmers code this @myString in one place and @MySTring in another and from my background this is two different variables.
Something to make all the variables consistent with the casing of DECLARE statement.
So
DECLARE @myString varchar(250)
SET @MYString ='This is annoying to me'
Exec 'Select.....' + @mySTRING + ' from tblRater'
to
DECLARE @myString varchar(250)
SET @myString ='This is annoying to me'
Exec 'Select.....' + @myString + ' from tblRater'
Thanks!
SJ
I see alot of my VB programmers code this @myString in one place and @MySTring in another and from my background this is two different variables.
Something to make all the variables consistent with the casing of DECLARE statement.
So
DECLARE @myString varchar(250)
SET @MYString ='This is annoying to me'
Exec 'Select.....' + @mySTRING + ' from tblRater'
to
DECLARE @myString varchar(250)
SET @myString ='This is annoying to me'
Exec 'Select.....' + @myString + ' from tblRater'
Thanks!
SJ
Comments
Thanks for writing. We could consider this as an additional option, but for the sake of accuracy, SQL Server, when using the default collation order, considers @myString and @MyString as the same variable. If the server was using a case-sensitive collation, these would be considered two distinct variables.