Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Poor mans T-SQL formatting add-in "Format T-SQL Code" option disabled in SQL Server Management Studio v18.5

Tags:

ssms-18

Refer to the following screenshot:

enter image description here

In the previous versions of SQL Server Management Studio, it was working perfectly. I am using Windows 10 on a desktop PC.

Appreciate any help for this :)

like image 945
Hardipsinh Jadeja Avatar asked Aug 08 '20 09:08

Hardipsinh Jadeja


People also ask

How do I beautify in SQL?

MYSQL Formatter allows loading the SQL URL to beautify. Use your SQL URL to beautify. Click on the URL button, Enter URL and Submit. Users can also beautify and remove the comments from SQL.

What is poor SQL?

PoorSQL.com is an online SQL formatting service that uses the Poor Man's T-SQL Formatter library. This is an open-source ( AGPL-licensed) C#/.Net 2.0 library, and the library, plugins and source are all available for download on the project page. The source code is.

What is poor man's T-SQL formatter - VS Code Extension?

Poor Man's T-SQL Formatter - VS Code Extension. This is a Visual Studio Code extension for Poor Man's T-SQL Formatter, a SQL formatting library available in a variety of other editors & IDEs. This formatter's special focus on T-SQL (the SQL dialect of Microsoft SQL Server... and Sybase/SAP Adaptive Server Enterprise) makes Visual Studio Code...

Does Poorman's T-SQL formatter support SMSs 2014-2018?

For the versions of the plugin that supports SMSS 2014-2018, PoorMan's T-SQL Formatter requires the Visual Studio 2015 Isolated Shell installed in order to work. It can be downloaded from here. After installing it, the option will be made available.

What is the T-SQL formatter for Visual Studio Code?

Get it now. This is a Visual Studio Code extension for Poor Man's T-SQL Formatter, a SQL formatting library available in a variety of other editors & IDEs. This formatter's special focus on T-SQL (the SQL dialect of Microsoft SQL Server... and Sybase/SAP Adaptive Server Enterprise) makes Visual Studio Code a sensible target for support.

How to format T-SQL code in SSMS?

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.


1 Answers

For the versions of the plugin that supports SMSS 2014-2018, PoorMan's T-SQL Formatter requires the Visual Studio 2015 Isolated Shell installed in order to work. It can be downloaded from here. After installing it, the option will be made available.

The formatter is now enabled.

like image 137
Jesús Hagiwara Avatar answered Sep 21 '22 09:09

Jesús Hagiwara