Finding unused variables and parameters
Published 11 February 2013
Finding unused variables and parameters is available only in SQL Prompt Pro Edition.
SQL Prompt allows you to find any parameters or variables that are unused in a script.
A parameter or variable is considered to be unused if it has been declared or assigned a value, but not queried or used in any control statements, and not used in INSERT or UPDATE statements, WHERE clauses, PRINT or EXECUTE statements, loops or case statements, and so on.
To find unused variables and parameters:
- Open the script you want to use in a SQL Server Management Studio query window.
- If required, select the block of SQL that contains the parameters and variables that you want to check.
If you do not select any SQL, all parameters and variables in the script are checked. - On the SQL Prompt menu, click Find Unused Variables and Parameters.
Unused parameters, variables, and values are underlined in the query:
Keyboard shortcut: hold Ctrl and press B then F to find unused variables and parameters in the selected script. (SQL Prompt 5.3 only)
