ChatGPT解决这个技术问题 Extra ChatGPT

Management Studio 2012 的 Poor Mans T-SQL 格式化加载项是否在 Management Studio 2014 中工作?

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

In SSMS 2012, if I go to tools, it showed up in the list. In SSMS 2014, it doesn't.

I tried to run the installer again, and it gave me options to repair or uninstall. I had the formatter installed prior to installing 2014.

EDIT: The tool is available here.

Can you please provide a link to the tool you are asking about?
Sounds like it doesn't work. The add-in mechanism changed slightly between versions, but really, you should be contacting the add-in's authors to find this out.
Is there a rich man's SQL formatter?
@popovitsj Yeah, it's called Red Gate
Might be of interest to people that the free tool SSMSBoost has this feature and more ssmsboost.com

W
War10ck

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

Confirmed that this also works with SQL 2016 CTP. You just need to add the folder as "13.0".
This works, just make sure to follow path names exactly. I now get a Format Sql menu under Tools.
Seems to be broken in the latest 2016 version with updated visual studio shell running in isolated mode. Anyone get it to work.
I guess issue is that SSMS 2016 no longer supports addings, everything is a extension now. Code needs to be updated to support SSMS 2016 and upwards.
For SSMS 2017 Adding folder 14.0 and copying the add-in doesn't work for me
T
Tao

UPDATE: more than three years later, this support has finally been added.

Download page is still http://architectshack.com/PoorMansTSqlFormatter.ashx for now.


Your tool is awesome. Please do let me know when it's updated!
Note: this is open source so if you have the time to make the simple change you can contribute. Would be nice for 2016 as well. architectshack.com/PoorMansTSqlFormatter.ashx#Contributing_11
FYI - Currently trying to get this working in SSMS 17.1... hold my beer.
@CaptainMarvel sorry about the wait, this is finally done (including SSMS 17) - download in the usual place.
When I execute PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16.msi for SSMS v18.1 then I do not see PoorMansTSqlFormatterSSMSAddIn.dll anywhere in my system.I copy this dll from another system .Do dll version matter ? Why dll not getting downloaded.
A
Andrei Rantsevich

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".


I switched to using this plugin because the poor man's SQL formatter hasn't updated it's code base to work with 2014
Tried this, but could not find a way to format the sql code, no menu option.
After installing SSMSBoost, you see it's toolbar. It contains "Format SQL" button. Near this button there is a drop-down where you can choose formatting engine and templates. If you have problems - write us to support@ssmsboost email
This tool has it all - I'm very impressed. admitally; I haven't seen the price yet.
K
Karl Kieninger

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.


@Hoppe sorry for the confusion. My typing is lousy. Corrected.