• Sean Smith-776614 (2/26/2014)


    No harm, just cleaner code.

    It must cost something for the system to prepare for the possibility that this unused parameter may be passed in. Or is it such a miniscule amount of time and space that it isn't even worth thinking about?

    I would assume the calling procedures still need to be passing in values, even though they are just ignored by the stored procedure, unless they are optional parameters. Does t-sql allow optional parms?