alter table OtherProperties alter column Price decimal (19,4) null alter table OtherProperties alter column Tarikh int null alter table OtherProperties alter column TarikhAz int null alter table OtherProperties alter column TarikhEla int null alter table OtherProperties alter column Priority int null alter table OtherProperties alter column tarikhsabt int null alter table OtherProperties alter column saatSabt smallint null IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND COLUMN_NAME = 'PriceAz') begin alter table OtherProperties add PriceAz decimal(19,4) end go IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND COLUMN_NAME = 'PriceEla') begin alter table OtherProperties add PriceEla decimal(19,4) end go IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND COLUMN_NAME = 'flag') begin alter table OtherProperties add flag bit end go IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND COLUMN_NAME = 'Percent') begin alter table OtherProperties add [Percent] float end go