Quite often when troubleshooting a stored procedure, it is helpful to step through it and run each statement individually. In stored procedures that take parameters, though, you need to manually swap out the variable name for a test value in each statement, or put variable declarations and sets in front of each statement.

It would be convenient if SQL Prompt could automate this process. It could check for parameters, prompt the user to provide values for them, then do the variable-to-literal substitution throughout the code. It could then provide an easy way to reverse the change to support committing the edited code.