Few days ago, I received code which is very similar to code shown below.
select *
from Sales.SalesOrderDetail
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.
SELECT *
FROM Sales.SalesOrderDetail
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 (https://blog.sqlauthority.com)
