Variable Declaration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Variable Declaration

Variable Declaration

Rate Topic

Display Mode

Topic Options

Author

Message

harsh.dhawan

Posted Tuesday, August 12, 2008 2:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, August 12, 2008 4:15 AM
Points: 6, Visits: 23

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

Post #550792

John H Marsh

Posted Tuesday, August 12, 2008 4:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, February 28, 2013 1:54 AM
Points: 1,325, Visits: 1,376

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

Post #550841

« Prev Topic | Next Topic »

Permissions