ALTER TABLE Tickets ADD COLUMN IsMerged smallint NULL DEFAULT NULL; UPDATE Tickets SET IsMerged = 1 WHERE id != EffectiveId;