Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# admin

- Joined: November 19, 2009
- Articles: 40

- sql pretty printer

## The error code 2869 while install/remove SQL Pretty Printer add-in for SSMS

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…

- admin
- March 28, 2012

- release, sql pretty printer

## New release: SQL Pretty Printer Version 3.2.8

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…

- admin
- October 14, 2011

- formatting, sql, wordpress

## How to add syntax colored and well formatted SQL in your wordpress blog

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…

- admin
- October 4, 2011

- format option, sql pretty printer, v238

## case(Capitalization) user defined identifier in SQL statement

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,…

- admin
- October 4, 2011

- format option, sql pretty printer, v238

## Upper case or lower case variable name in SQL statement

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:…

- admin
- October 4, 2011

- format option, sql pretty printer, v238

## Upper case or lower case alias name in SQL statement

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:…

- admin
- October 4, 2011

- format option, sql pretty printer, v238

## Upper case or lower case column name in SQL statement

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:…

- admin
- October 4, 2011

- format option, sql pretty printer, v238

## Upper case or lower case table name in SQL statement

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:…

- admin
- October 4, 2011

- format option, sql pretty printer

## Case(capitalization) options used when formatting SQL statements

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.…

- admin
- October 4, 2011

- formatting, sql

## Case (Capitalization) in SQL statement

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…

- admin
- September 29, 2011