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