Options

"Find Unused Variables and Parameters" at command line

opc.threeopc.three Posts: 17 New member
edited February 16, 2011 4:49PM in SQL Prompt Previous Versions
I am a big fan of SQL Prompt! The "Find Unused Variables and Parameters" feature is very useful and has allowed us to clean up many wasteful declarations as we work on existing objects. All of our database objects are stored as .sql files and checked into a source control repository. It would be great if we could run "Find Unused Variables and Parameters" against each file and have a report generated showing any unused variables and parameters within those scripts. Thanks!
· Share on Twitter

Comments

  • Options
    Luke JeffersonLuke Jefferson Posts: 37
    Hi,

    Thanks for posting to this forum and sharing your suggestion.

    I agree that it would be useful to run the feature in this way but sadly due to the way it's currently implemented would not make this is a trivial addition.

    Can I ask how you currently source control your .sql scripts? We might look at introducing these types of checks to our Source Control product.

    In any case, I have made a note of your request and will look into doing this in the future should we rework this portion of the code base.

    Please feel free to email me directly with any more suggestions.

    All the best,

    Luke Jefferson
    Product Manager
    Red Gate Software
    E: luke.jefferson@red-gate.com
    · Share on Twitter
Sign In or Register to comment.