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