Unused Input Parameters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sean Smith » Unused Input Parameters

Unused Input Parameters

Rate Topic

Display Mode

Topic Options

Author

Message

Sean Smith-776614

Posted Wednesday, December 19, 2012 2:51 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Comments posted to this topic are about the item Unused Input Parameters

Post #1398254

charles.jacobus-765275

Posted Wednesday, December 19, 2012 10:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 4:19 PM
Points: 3, Visits: 55

Nice! I've been thinking about this as well. But the problem has been how to exclude comments in the query of the module definition. For example, if I've got a @ParamA parameter that's not used in the code but is included in a comment, I still want this reported since the parameter isn't used. It just happens to be referenced in a comment.

Post #1398537

Sean Smith-776614

Posted Wednesday, December 19, 2012 10:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Very interesting! I had not considered this. The issue would be identifying such a case since comments can be in many different forms:

--@my_unused_parameter

-- @my_unused_parameter

-- need to clean this up one day! -> @my_unused_parameter

/* @my_unused_parameter */

/*
@my_unused_parameter
*/

Etc... You've given me some food for thought. Thanks for sharing! :)

Post #1398548

« Prev Topic | Next Topic »

Permissions