Hello,

Try with GO before UPDATE:

IF(SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS

 WHERE TABLE_NAME = 'mytable'

 AND COLUMN_NAME = 'mycol'

   ) = 0

ALTER TABLE mytable ADD mycol int not NULL DEFAULT (0)

GO

UPDATE mytable SET mycol = myval

Liliana.