April 4, 2012 at 9:14 am
Hello Everyone
I am trying to set some standards in our company. And it is working!
I would like to ensure that all Developers use Uppercase for SQL Keywords. I cannot find any place in SSMS to enforce this. Does anyone know how this can be added, if it even can be.
I have set the Colors, and Font size, etc... but so far found nothing for setting things like all Uppercase for the Keywords.
Thanks in advance for all your help
Andrew SQLDBA
April 4, 2012 at 9:30 am
You could try with Poor Man's SQL Formatter SSMS Add-in.
It doesn't enforce UPPERCASE keywords, but can convert and format the code consistently.
-- Gianluca Sartori
April 4, 2012 at 9:44 am
To be honest, I'd rather have an automated method of enforcing the UPPER CASE on SQL reserved words, even if it meant me hitting a sequence of control keys to initiate.
While writing code I use mostly lower case, don't have to hold the shift key or remember to use the shift lock while typing select or insert.
April 4, 2012 at 10:34 am
The SSMS Tools Pack can do that:
It can also save queries that you've run and windows you have open which can be very handy.
April 4, 2012 at 10:39 am
Thanks Everyone
I appreciate all the comments.
Andrew SQLDBA
April 4, 2012 at 11:55 am
You could also purchase SQL Prompt (Redgate) or SQL Assistant (SoftTree) and configure those to your standard. This way, you don't have to worry about hitting the shift key, uppercase, etc... as both tools automatically uppercase/lowercase/mixed case keywords as you type.
I personally use SQL Assistant - which is much more customizable than SQL Prompt, and has the advantage of being available for other databases and other editors.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply