Format SQL code using SSMS optionsSSMS provides a couple of options to format SQL code. Those options are indenting, tab sizing, make all code in upper or lower case, comment/uncomment selected code, etc.
Conclusion. As we can see it is possible to install only SQL Server Management Studio on a local machine (without installing the SQL Server database engine and its other components) and connect using SSMS to a remote SQL Server instance.
Regardless of the edition being used, SQL Server Management Studio only comes in one flavor and boasts backwards compatibility with almost all features from versions 2008 to 2019, including SQL Azure support.
Create the folder
%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\
if it does not exist. Then just copy the file from:
%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\11.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn
to
%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn
UPDATE: more than three years later, this support has finally been added.
Download page is still http://architectshack.com/PoorMansTSqlFormatter.ashx for now.
With the permission of the PoorMans Formatter developer we have integrated it in our add-in "SSMSBoost". Recent version of SSMSBoost supports SSMS 2014, so you can use it to use Poor Man's formatter features. We have already developerd our own formatting engine, but have left "Poor Man's formatter" for backward compatibility, for those users, used to it. You will find it in formatter-styles drop-down as "Old fashioned formatting style".
No, it has not been updated yet.
As of 2014-04-25 the most recent built is from 2013-10-23, version 1.5.3.
http://architectshack.com/PoorMansTSqlFormatter.ashx#Latest_Changes_6
Edit:
Since I hadn't installed the plug-in on my new machine with 2014 I went a head and tried. It does not work on my fresh install, but does still on the side-by-side 2012.
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