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

- 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

- format option, sql pretty printer, v238

## sql formatter option: how to place a comma in the list of parameter in execute statement

This format option controls where to put comma in the list of parameters of SQL Server execute statement. a line break can be placed after comma, or before comma name: exec_parameters_comma_option, default is put line break after comma setting path:…

- admin
- September 29, 2011

- format option, sql pretty printer, v238

## sql formatter option: list style of parameter in execute statement

This format option controls whether list style of parameters in SQL Server execute statement, it can be stacked or wrapped. name: exec_parameters_style, default is stacked setting path: Execute -> parameter style EXEC Spr_store_note @NoteId = 0, @TableTypeId = @TABLE_CUSTOMER, @RecordId = @CustomerId, @Descr = @Comments After set exec_parameters_style to…

- admin
- September 29, 2011

- format option, sql pretty printer, v238

## sql formatter option: align value of parameter in execute statement

This format option controls whether align value of parameter of SQL Server execute statement. name: exec_parameters_align_value, default is false setting path: Execute -> align value of parameter EXEC Spr_store_note @NoteId = 0, @TableTypeId = @TABLE_CUSTOMER, @RecordId = @CustomerId, @Descr = @Comments After set exec_parameters_align_value to true, SQL will be formatted…

- admin
- September 29, 2011

- format option, sql pretty printer, v238

## sql formatter option: first parameter of execute statement in new line

This format option controls whether put a blank line before the first parameter of SQL Server execute statement. name: exec_first_paramater_in_newline, default is true setting path: Execute -> first parameter in newline EXEC Spr_store_note @NoteId = 0, @TableTypeId = @TABLE_CUSTOMER, @RecordId = @CustomerId, @Descr = @Comments After set exec_first_paramater_in_newline…

- admin
- September 28, 2011

- best practices, sql

## A list of SQL best practices

Here are some SQL programming guidelines and best practices we collected, keeping quality, performance and maintainability in mind. This list is not complete at this moment, and will be constantly updated. Do not use SELECT * in your queries. Always…

- admin
- September 27, 2011

- format option, sql pretty printer, v238

## SQL FORMATTER OPTION: SUBQUERY NEWLINE BEFORE COMPARISON OPERATOR

This format option control whether put a blank line before comparison operator when it follows a subquery. name: Subquery_Newline_Before_ComparisonOperator, default is false setting path: subquery -> Linebreak before comparison operator SELECT c.[Categoryid] AS [categoryid], c.[Categoryname], c.[Picture] FROM [northwind].[dbo].[CATEGORIES] c WHERE (((( (SELECT Sum([lpa_l1].[Unitsinstock]) AS [lpav_] FROM (SELECT p.[Categoryid] AS [categoryid], p.[Unitsonorder] FROM [northwind].[dbo].[PRODUCTS] p WHERE (( p.[Categoryid] = c.[Categoryid] ))) [lpa_l1]) > @p2 )))) After…

- admin
- September 27, 2011

- format option, sql pretty printer, v238

## SQL Formatter Option: Subquery newline after comparison operator

This format option control whether put a blank line after comparison operator when there is a subquery follows. name: Subquery_Newline_After_ComparisonOperator, default is false setting path: subquery -> Linebreak after comparison operator SELECT * FROM T WHERE Somefield = (SELECT TOP 1 Blah FROM T1 ORDER BY F) After set Subquery_Newline_After_ComparisonOperator to…

- admin
- September 27, 2011