ALTER TABLE dbo.FW_PATROL_TASK ADD CRUISE_TYPE INT;
UPDATE FW_PATROL_TASK
SET CRUISE_TYPE = 0;
--设置新列的值为0
ALTER TABLE FW_PATROL_TASK ALTER COLUMN
CRUISE_TYPE INT NOT NULL;
ALTER TABLE dbo.FW_PATROL_TASK ADD CRUISE_TYPE INT;
UPDATE FW_PATROL_TASK
SET CRUISE_TYPE = 0;
--设置新列的值为0
ALTER TABLE FW_PATROL_TASK ALTER COLUMN
CRUISE_TYPE INT NOT NULL;