Declare @Id Int                               
Select @Id = Id From sysobjects Where Name = 'Price_Sazman'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id  and Name = 'BimarPercent')
Alter Table Price_sazman Add BimarPercent smallint Null

Select @Id = Id From sysobjects Where Name = 'tmpDrugHavaleh'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id  and Name = 'BimarPercent')
Alter Table tmpDrugHavaleh Add BimarPercent smallint Null

Select @Id = Id From sysobjects Where Name = 'DrugHavaleh'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id  and Name = 'BimarPercent')
Alter Table DrugHavaleh Add BimarPercent smallint Null

