In Visual Studio & other IDEs, you can easily auto format your code with a keyboard shortcut, through the menu, or automatically as you type.
I was wondering if there is yet a way to enable this standard feature in SQL Server Management Studio?
I'm working with some large-ish stored procs that are a mangled mess of poorly formatted SQL and it'd be nice if I could just go "Select All -> Format SQL"
Azure Data Studio - free and from Microsoft - offers automatic formatting (ctrl + shift + p while editing -> format document). More information about Azure Data Studio here.
While this is not SSMS, it's great for writing queries, free and an official product from Microsoft. It's even cross-platform. Short story: Just switch to Azure Data Studio to write your queries!
Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS.
Update: Actually Azure Data Studio is in some way the recommended tool by Microsoft for writing queries (source)
Use Azure Data Studio if you: [..] Are mostly editing or executing queries.
While for some reason Microsoft ignores to implement this in SSMS I found the following site which does a pretty good job of formatting the SQL Code:
https://www.red-gate.com/website/sql-formatter
Also
https://codebeautify.org/sqlformatter
Even though this one is also fairly nice, but the code it produces is a bit too verbose for me so my favorite is
red-gate.com