Variable Declaration

• harsh.dhawan

  SSC Enthusiast

  Points: 102

  More actions

  August 12, 2008 at 2:01 am

  #196951

  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

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  August 12, 2008 at 4:11 am

  #856565

  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