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

# Upper case or lower case variable name in SQL statement

- admin
- October 4, 2011
- format option, sql pretty printer, v238

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: capitalisation -> Variable

EXECUTE Sp_executesql
@query,
n’@age int’,
@age = 25

After setting case_variable_name to upper case,

EXECUTE Sp_executesql
@QUERY,
n’@age int’,
@AGE = 25

### Newsletter Updates

Enter your email address below to subscribe to our newsletter

I accept the Privacy Policy

### Related Posts

#### NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.3

- September 19, 2012

#### NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2

- July 18, 2012

#### SQL Pretty Printer works when Multi-SSMS installed

- July 5, 2012