If you encounter error code 2869 while install/remove SQL Pretty Printer add-in for SSMS, this is mainly because you install this program as a standard user and just click ppforssmssetup.msi. This problem can be easily fixed by running setup.exe under…
Introduce 14 new format options in this version and there are more than 90 format options in SQL Pretty Printer. Fix a bug that menu and toolbar disappeared in vs2010 after first installation. About 2 times faster when format some…
People always post SQL code into blogs and forums need a tool to help them to prepare dull monochrome, badly-formatted SQL code for HTML-based publication in a nice clean style. SQL Pretty Printer is able to output HTML in both…
SQL Pretty Printer provides the ability to capitalize user defined identifier such as stored procedure name start with sp_ in SQL Server. name: case_prefix_identitfer setting path: capitalisation -> Prefix_ident name: identifier_prefix_list setting path: capitalisation -> Identifier prefix list EXECUTE Sp_executesql @query,…
Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of variable name in SQL statement, this feature helps you to find out variable in SQL statement quickly. name: case_variable_name, default is no change. setting path:…
Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of alias name in SQL statement, this feature helps you to find out alias in SQL statement quickly. name: case_alias_name, default is no change. setting path:…
Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of column name in SQL statement, this feature helps you to find out columns in SQL statement quickly. name: case_column_name, default is no change. setting path:…
Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of table name in SQL statement, this feature helps you to find out tables in SQL statement quickly. name: case_table_name, default is no change. setting path:…
There are 5 case options available while formatting SQL tokens in SQL Pretty Printer. 1. Uppercase(All caps): All letters are capital letters. 2. Lowercase: All letters are lower case. 3. InitCap: Only the first letter of the whole word capitalized.…
When format SQL query, capitalization refers to the way in which SQL token should or should not be capitalized in your code. For example, some developers prefer to make all reserved keys uppercase, others prefer lowercase, and some mix and…
