Red Gate forums :: View topic - Feature Request...variable casing consistency...
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

Feature Request...variable casing consistency...

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
swjohnson



Joined: 18 Jul 2005
Posts: 21
Location: Lincoln, NE USA

PostPosted: Fri Jan 19, 2007 11:35 pm    Post subject: Feature Request...variable casing consistency... Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Tue Jan 23, 2007 5:55 pm    Post subject: Reply with quote

Hi SJ,

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.
Back to top
View user's profile Send private message
darren



Joined: 02 Apr 2009
Posts: 1

PostPosted: Thu Apr 02, 2009 4:44 pm    Post subject: Reply with quote

Can this be revisited as an optional feature in SQL Refactor? Having the option to make variable names conform to a standard is something that would benefit me greatly. Yes, there is the issue of working on a CS server, but I don't think it's good practice to differentiate variables solely on case!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group