>>>It still doesn't work.
>>>
>>>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
>>> UPDATE Volunteers SET IsActive = 1
>>>END
>>>
>>>Gives me an error on UPDATE line.
>>
>>Did you have BEGIN TRANSACTION before that code?
>
>No.
What if:
IF NOT EXISTS(SELECT column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Volunteers' and COLUMN_NAME = N'IsActive')
BEGIN
alter table Volunteers
add IsActive bit NOT NULL CONSTRAINT [DF_Volunteers_IsActive] DEFAULT (1)
END
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.