PoorMans Free SQL Server Database T-SQL Formatting Program
- jordan shoes for sale
- 16373
|
Poor Man's T-SQL Formatter
This is a free open source SQL (T-SQL) formatter:
- Handles complete multi-batch scripts, including object definition scripts such as stored procedures, triggers, etc.
- Provides formatting options to meet different common formatting styles/standards.
- Optionally outputs "colored" html code instead of just formatted SQL.
- Also provides a "shrinker" option to remove comments and spaces to obfuscate rather than pretty up your printed code. Code
- Ready-to-use
- SSMS (SQL Server Management Studio) and Visual Studio plug-ins/extensions are available in a variety of formats, allowing you to format the current file or selected text with a single hotkey - any version of SSMS or SSMS Express is supported, as well as any full (non-Express) version of Visual Studio. Notepad++ is also available. Visual Studio.
- Notepad++ plug-in for quick single-key formatting in your favorite general-purpose text editor.
- Command line utility that lets you batch format any number of files, or format from any other program - for windows (.Net) or any environment (node/npm)
- Winforms application for easy offline formatting (also lets you view token streams and parse trees)
- WinMerge plug-in for automatically formatting before comparing SQL files prior to comparison, allowing WinMerge to display only content changes and ignore formatting differences.
- JS library that exposes the same functionality in any browser or other Javascript-based context for demo/online formatting sites http://poorsql.com
- Also available as a .Net 2.0/3.5 library, downloadable here or via NuGet
- Written in C#, pluggable design, should support other SQL dialects in the future
Official website: http: //architectshack.com/PoorMansTSqlFormatter.ashx
GitHub address: https: //github.com/TaoK/PoorMansTSqlFormatter
Online SQL formatting: http: //poorsql.com/
Poor Man's T-SQL Formatter has plug-ins for Visual Studio, SSMS, Notepad++, etc. It can be well inherited with other tools, take SSMS plug-in as an example, download address: http: //architectshack.com/GetFile.aspx?Page= PoorMansTSqlFormatter&File=PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16.msi
 PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16.msi(692 KB, downloads: 0, msrp: 3 grains MB)
I have SQL Server Management Studio version: 15.0.18390.0 installed locally as shown below:
sql server 2016 installation completed without management tools (SSMS)
h ttps:// www.itsvse.com/thread-8281-1-1.html
Before installing PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16, the computer needs to have the .NET Framework 2.0 runtime installed or it will report the following error:
Installation steps, from the control panel to enable or disable Windows features to check the installation can be, as shown below:
Install PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16 again successfully, open "Microsoft SQL Server Management Studio 18" reported the following error:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
The "FormatterPackage" package is not loaded correctly.
This issue may be caused by a configuration change or the installation of another extension. Details can be obtained by looking at the file "C:\Users\itsvse_pc\AppData\Roaming\Microsoft\AppEnv\15.0\ActivityLog.xml".
Restarting Visual Studio may help resolve this issue.
Do you continue to display this error message?
---------------------------
Yes (Y) No (N)
---------------------------
Solution, open the installation directory, for example: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE folder, edit the Ssms.exe.config file and add the following:
Open the Microsoft SQL Server Management Studio 18 tool again, no longer reporting errors, and enter a SQL statement as shown below:
Click Tools -> Format T-SQL Code, or the shortcut keys Ctrl+K, F ( you need to release Ctrl before clicking F ), the effect picture after formatting is as below:
(End)
|
Previous：Angular block the trigger of the parent class click eventNext： [Hands-on] iPhone message notification push of Bark application
|
发表于 2022-4-9 14:48:25
Relay
