PoorMansTSqlFormatter
PoorMansTSqlFormatter copied to clipboard
TaoK
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...
How does sublime text use the PoorMansTSqlFormatter plug-in to format SQL, and how can it be easily used like Notepad++ with custom formatting. Sublime Text 如何使用PoorMansTSqlFormatter插件, 格式化SQL, 如何像Notepad++方便的使用该插件, 并且可以自定义格式.
I have disabled actions menu (see picture). It looks that SSMS disable it, but i don't know why. Any experience with this? 
Hi! I'm using this great extension in Notepad++, but unlike all the others, PoorMansTSqlFormatter doesn't add any button in the toolbar, so I have to go to Extension Modules/Poor Man's...
On case statements, the keyword then has surrounding spaces removed. "values case when 12 4 then 'A' else 'B' end" becomes "values case when 124then'A'else'B'end". Its odd that "case when...
If I mimify this statement. select * from TABLE_NAME_A A inner join TABLE_NAME_B B on A.COLUMN = B.COLUMM left join TABLE_NAME_C C on A.COLUMN = C.COLUMN where C.COLUMN is not...
…move brackets around names (schemas, tables, columns, aliases, etc.) Example: -ab | -addBracketsAroundNames >echo select abc from def where ghi = 1 | SqlFormatter -ab SELECT [abc] FROM [def] WHERE...
I am getting a warning message when cloning the repo. Please find the message enclosed C:\LavanyaDeepak\Research and Development>git clone https://github.com/TaoK/PoorMansTSqlFormatter.git Cloning into 'PoorMansTSqlFormatter'... remote: Enumerating objects: 4180, done. remote: Total...
`DROP PROCEDURE IF EXISTS dbo.Procedure` causes dialog: **Errors found. Continue?** _Errors found during SQL parsing. Would you like to apply formatting anyway?_ Yes No
This is code from www.sqlservertutorial.net/sql-server-views/sql-server-get-view-information/ It allows us to view the code in a view. SELECT definition, uses_ansi_nulls, uses_quoted_identifier, is_schema_bound FROM sys.sql_modules WHERE object_id = object_id( 'sales.daily_sales' ); The Character...
