>>IF NOT EXISTS >>(SELECT column_name >>FROM INFORMATION_SCHEMA.COLUMNS >>WHERE TABLE_NAME = N'Volunteers' and COLUMN_NAME = N'IsActive') >>BEGIN >> SET @SQLString = N'alter table Volunteers add IsActive bit null CONSTRAINT [DF_Volunteers_IsActive] DEFAULT ((1))' >> EXECUTE sp_executesql @SQLString -- Only to be in other batch >> UPDATE Volunteers SET IsActive = 1 >>END>>