SQL SERVER – Upper Case Shortcut SQL Server Management Studio
Posted by karuta em setembro 29, 2012
Few days ago, I received code which is very similar to code shown below.
where ProductID > 777
I am not the guy who go crazy for formatting but I do appreciate proper coding. I like if the code was formatted like below.
WHERE ProductID > 777
The fastest way one can do this in SSMS is either search and replace or using SSMS short cut to covert keywords to upper case.
What I do is I select the word and hit CTRL+SHIFT+U and it SSMS immediately changes the case of the selected word. Similar way if one want to convert cases to lower case, another short cut CTRL+SHIFT+L is also available.
Reference: Pinal Dave (http://blog.SQLAuthority.com)