if (select count(*) from sys.syscolumns where tname='SpaMedicalOffices' and cname='Active')=0 then

alter table SpaMedicalOffices
Add Active integer default 1

end if

GO

Update SpaMedicalOffices
Set Active=1
where Active is Null