Menu
I mean, something equivalent to Ctrl + K + D from Visual Studio that automatically indents code. Is there something in this sense?
878
Select the text you want to indent. Press TAB, or click the Indent button on the Standard toolbar.
Format SQL Code in SSMS Query Window To use the SSMS add-in component we will have to close and then open SSMS after the install of the add-in. Then open a SSMS query window, highlight the code that needs to be formatted. Then select Format T-SQL Code from the SSMS Tools menu. Here is the code after the formatting.
How to Enable IntelliSense Feature in SSMS. Open SSMS, click Tools -> Options -> Expand Text Editor -> Expand Transact-SQL and click on IntelliSense as shown in the snippet below. Under Transact-SQL IntelliSense Settings ensure “Enable IntelliSense” checkbox is enabled.
Just discovered this - yet another variation on this older question which has much more activity: SQL Formatter for SQL Management Studio
I personally am a big fan of the Poor Man's T-SQL Formatter / http://poorsql.com - but then I wrote it :)
178
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
