Variable Declaration

  • Hi Friends

    I am going through a piece of code in SQL server. My programmer has declared around 20-25 variables in his program which are not used anywhere in it.

    What will be the after affects of declaring the variables and not using them in the procedure?

    Cheers

  • Hello,

    I would not expect this to cause any problems. The SP(?) will take up slightly more Server memory when executing.

    If the variables are not used anywhere in the code then it would be straight forward to remove the declarations.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply