PoorMansTSqlFormatter
PoorMansTSqlFormatter copied to clipboard
A small free .Net and JS library (with demo UI, command-line bulk formatter, SSMS/VS add-in, notepad++ plugin, winmerge plugin, and demo webpage) for reformatting and coloring T-SQL code to the user's...
I get this error when installing the PoorMansTSqlFormatterSSMSPackage.Setup.1.6.11.msi package from http://architectshack.com/PoorMansTSqlFormatter.ashx#Download_5 I haver SSMS 17.4 installed. Microsoft SQL Server Management Studio 14.0.17213.0 Microsoft Analysis Services Client Tools 14.0.1016.232 Microsoft Data...
I get the following error when i install the extension.  I am using ssms 18.4 The error from the log is this `CreateInstance failed for package [FormatterPackage]Source: 'mscorlib' Description:...
I use this site daily to format and colorize my SQL for sharing with others and have issues where the website no longer allows me to input any text on...
The tool doesnt recognize _drop view if exists_ as a key word. This issue also causes poor identation for the rest of the document INPUT ```sql use views; drop view...
ALTER VIEW xxx AS ... the SQL after this to be indented
``` ALTER PROCEDURE [dbo].[spr_TEST] @date DATE ,@location BIGINT AS BEGIN DECLARE @C_SIMPHONY INT = 22005 ,@abc BIGINT = 4 END ``` to show as ``` ALTER PROCEDURE [dbo].[spr_TEST] @date DATE...
Clearly this is dependent on the application that uses the extension, but it's really unclear how to invoke the functions. Could there be some documentation added for each app that...
I have created a nuget package for this library: http://nuget.org/packages/PoorMansTSQLFormatter/ I apologise if this is not what you would like, in which case please do say so and I will...
- use vs2017 for x86,x64 appveyor builds - avoid build issue, by adding the missing package files: Project "C:\projects\poormanstsqlformatter\PoorMansTSqlFormatter.sln" (1) is building "C:\projects\poormanstsqlformatter\PoorMansTSqlFormatterVSPackage2019\PoorMansTSqlFormatterVSPackage2019.csproj" (5) on node 2 (default targets). 5>C:\projects\poormanstsqlformatter\PoorMansTSqlFormatterVSPackage2019\PoorMansTSqlFormatterVSPackage2019.csproj(133,5):...
The [homepage](http://architectshack.com/PoorMansTSqlFormatter.ashx) writes: > The new Plugin -> Admin feature doesn't yet support Poor Man's T-SQL Formatter, but should soon I'v been able to install with Plugins -> Admin np++...